Tricky DB2 question on SELECT statement

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
Advertisements

Author: Srini

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