SQL SELECT Statement 5 Associated Clauses

by Srini
Posted on January 23, 2017March 14, 2022

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

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe. View all posts by Srini