SQL is followed by a unique set of rules and guidelines called Sql Syntax.
All the SQL statements start with any of the keywords like
SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, CREATE, USE, SHOW
and all the statements end with a semicolon (;).
Various Syntax in SQL:
SQL SELECT Statement
SELECT column1, column2….columnN FROM table_name;
SQL DISTINCT Clause
|
1 2 |
SELECT DISTINCT column1, column2....columnN FROM table_name; |
SQL WHERE Clause
|
1 2 3 |
SELECT column1, column2....columnN FROM table_name WHERE CONDITION; |
SQL AND/OR Clause
|
1 2 3 |
SELECT column1, column2....columnN FROM table_name WHERE CONDITION-1 {AND|OR} CONDITION-2; |
SQL IN Clause
|
1 2 3 |
SELECT column1, column2....columnN FROM table_name WHERE column_name IN (val-1, val-2,...val-N); |
SQL BETWEEN Clause
|
1 2 3 |
SELECT column1, column2....columnN FROM table_name WHERE column_name BETWEEN val-1 AND val-2; |
SQL LIKE Clause
|
1 2 3 |
SELECT column1, column2....columnN FROM table_name WHERE column_name LIKE { PATTERN }; |
SQL ORDER BY Clause
|
1 2 3 4 |
SELECT column1, column2....columnN FROM table_name WHERE CONDITION ORDER BY column_name {ASC|DESC}; |
SQL GROUP BY Clause
|
1 2 3 4 |
SELECT SUM(column_name) FROM table_name WHERE CONDITION GROUP BY column_name; |
SQL COUNT Clause
|
1 2 3 |
SELECT COUNT(column_name) FROM table_name WHERE CONDITION; |
SQL HAVING Clause
|
1 2 3 4 5 |
SELECT SUM(column_name) FROM table_name WHERE CONDITION GROUP BY column_name HAVING (arithematic function condition); |
Hi there to every one, it’s genuinely a nice for me to go to see
this website, it consists of priceless Information.