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}

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s