Structure of the Query

                     Structure of the Query

Select */List_of_Columns/functions/experssions
[from table1(tab2............)]
[where condition]
[Group by col1,col2,........]
[Having condition]
[Order by col1,col2,.........]
[For XML modes]


But Execution wise the order will be different........

1. It starts from FROM clause
2. then WHERE clause
3. then Group by clause
4. then Having clause
5. then Select 
6. then Order by clause