SQL Basic Syntax

In this Article, we Discuss the SQL syntax for each of the SQL commands in this tutorial. The purpose of this page is to have a quick reference page for SQL syntax, so you can learn SQL more quickly.

1. Select Statement:
SELECT "column_name" FROM "table_name"

2. Distinct
SELECT DISTINCT "column_name"FROM "table_name"

3. Where:
SELECT "column_name"FROM "table_name"WHERE "condition"

4. And/OR: SELECT "column_name"FROM "table_name"WHERE " simple condition"{[ANDOR] "simple condition"}+In:SELECT "column_name"FROM "table_name"WHERE "column_name" IN ('value1', 'value2', ...)

5. Between: SELECT "column_name"FROM "table_name"WHERE "column_name" BETWEEN 'value1' AND 'value2'

6. Like: SELECT "column_name"FROM "table_name"WHERE "column_name" LIKE {PATTERN}

7. Order By: SELECT "column_name"FROM "table_name"[WHERE "condition"]ORDER BY "column_name" [ASC, DESC]

8. Count: SELECT COUNT("column_name")FROM "table_name"

9. Group By: SELECT "column_name1", SUM("column_name2")FROM "table_name"GROUP BY "column_name1"

10. Having: SELECT "column_name1", SUM("column_name2")FROM "table_name"GROUP BY "column_name1"HAVING (arithematic function condition)

11. Create Table Statement: CREATE TABLE "table_name"("column 1" "data_type_for_column_1","column 2" "data_type_for_column_2",... )

12. Drop Table Statement: DROP TABLE "table_name"

13. Truncate Table Statement: TRUNCATE TABLE "table_name"

14. Insert into Statements: INSERT INTO "table_name" ("column1", "column2", ...)VALUES ("value1", "value2", ...)

15. Update Statement: UPDATE "table_name"SET "column_1" = [new value]WHERE {condition}Delete From StatementDELETE FROM "table_name"WHERE {condition}