Perintah – perintah dalam SQL

  • Select Statement
    SELECT “column_name” FROM “table_name”


  • Distinct
    SELECT DISTINCT “column_name”
    FROM “table_name”


  • Where
    SELECT “column_name”
    FROM “table_name”
    WHERE “condition”


  • And/Or
    SELECT “column_name”
    FROM “table_name”
    WHERE “simple condition”
    {[AND|OR] “simple condition”}+


  • In
    SELECT “column_name”
    FROM “table_name”
    WHERE “column_name” IN (‘value1’, ‘value2’, …)


  • Between
    SELECT “column_name”
    FROM “table_name”
    WHERE “column_name” BETWEEN ‘value1’ AND ‘value2’


  • Like
    SELECT “column_name”
    FROM “table_name”
    WHERE “column_name” LIKE {PATTERN}


  • Order By
    SELECT “column_name”
    FROM “table_name”
    [WHERE “condition”]
    ORDER BY “column_name” [ASC, DESC]


  • Count
    SELECT COUNT(“column_name”)
    FROM “table_name”


  • Group By
    SELECT “column_name1”, SUM(“column_name2”)
    FROM “table_name”
    GROUP BY “column_name1”


  • Having
    SELECT “column_name1”, SUM(“column_name2”)
    FROM “table_name”
    GROUP BY “column_name1”
    HAVING (arithematic function condition)


  • Create Table Statement
    CREATE TABLE “table_name”
    (“column 1” “data_type_for_column_1”,
    “column 2” “data_type_for_column_2”,
    … )


  • Drop Table Statement
    DROP TABLE “table_name”


  • Truncate Table Statement
    TRUNCATE TABLE “table_name”


  • Insert Into Statement
    INSERT INTO “table_name” (“column1”, “column2”, …)
    VALUES (“value1”, “value2”, …)


  • Update Statement
    UPDATE “table_name”
    SET “column_1” = [new value]
    WHERE {condition}


  • Delete From Statement
    DELETE FROM “table_name”
    WHERE {condition}

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s