Tricky DB2 Interview 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. SELECTcolumn name(s)*
2. FROMtable or views
3. WHEREconditions or predicates are met
4. GROUP BYsubsets of rows
5. HAVINGa common condition as a group
6. ORDER BYa 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.