Various Syntax in SQL

Various Syntax in SQL 
All the examples given in this tutorial have been tested with a MySQL server.

SQL SELECT Statement 

SELECT column1, column2....columnN
FROM table_name;

SQL DISTINCT Clause

SELECT DISTINCT column1, column2....columnN
FROM table_name;

SQL WHERE Clause 
SELECT column1, column2....columnN
FROM table_name
WHERE CONDITION;

SQL AND/OR Clause 
SELECT column1, column2....columnN
FROM table_name
WHERE CONDITION-1 {AND|OR} CONDITION-2;

SQL IN Clause
SELECT column1, column2....columnN
FROM table_name
WHERE column_name IN (val-1, val-2,...val-N);

SQL BETWEEN Clause 
SELECT column1, column2....columnN
FROM table_name WHERE column_name
BETWEEN val-1 AND val-2;

SQL LIKE Clause 
SELECT column1, column2....columnN
FROM table_name
WHERE column_name LIKE { PATTERN };

SQL ORDER BY Clause 
SELECT column1, column2....columnN
FROM table_name
WHERE CONDITION
ORDER BY column_name {ASC|DESC};

SQL GROUP BY Clause
SELECT SUM(column_name)
FROM table_name
WHERE CONDITION
GROUP BY column_name;

SQL COUNT Clause 
SELECT COUNT(column_name) FROM table_name
WHERE CONDITION;