Keith Rull

I have been playing around with alot of SQL queries lately... with that, i have decided to compile a useful cue card to show basic keywords in SQL. I then went on to seach for websites that has an existing sql cue card and finally found one here. 

Here is the summary of the content of that site. You can also click the keyword to get a more detailed information about that keyword.

Select 
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
CREATE TABLE "table_name"
("column 1" "data_type_for_column_1",
"column 2" "data_type_for_column_2",... )

Drop Table
DROP TABLE "table_name"

Truncate Table 
TRUNCATE TABLE "table_name"

Insert Into 
INSERT INTO "table_name" ("column1", "column2", ...)
VALUES ("value1", "value2", ...)

Update
UPDATE "table_name"
SET "column_1" = [new value]
WHERE {condition}

Delete From
DELETE FROM "table_name"
WHERE {condition}