A Truly Fundamental of SQL Statements.

November 19, 2013 Billy Aung Myint No comments

The SELECT clause is used to restrict the columns , or expressions returned from the table.
The WHERE clause uses a condition to quantify or restrict the query results to only rows meeting the condition.
The GROUP BY clause is used to divide query result rows into smaller groups.
The HAVING clause is used to further restrict which groups will be returned.
The ORDER BY clause is used to sort the rows returned