There are total 5 clauses in any standard SQL SELECT statement.Each clause has its own purpose. By reading and hands on these, you will become expert in writing SELECT SQL query. Really awesome and simplified list. Good for refresh SQL or for ready to use in any project currently you are working in.
|1. SELECT||column name(s)*|
|2. FROM||table or views|
|3. WHERE||conditions or predicates are met|
|4. GROUP BY||subsets of rows|
|5. HAVING||a common condition as a group|
|6. ORDER BY||a sorting method|