SELECT STATEMENT CLAUSES

There are several clauses used with select statement, they are as follows

• WHERE CONDITION– It will restrict rows according to the condition.

• HIERARCHICAL_QUERY_CLAUSES– Structures the output in a hierarchical order.

• ORDER BY– Sorts the row.

• GROUP BY– Collect rows in group in order to identify value common to which group.

• HAVING CLAUSES– It is type of where clauses, It can be defined in GROUP BY Clauses.

Syntax:-  
 

SELECT [ALL | DISTINCT] column1[,column2] FROM table1[,table2] 

[WHERE "conditions"] 

[GROUP BY "column-list"] 

[HAVING "conditions] 

[ORDER BY "column-list" [ASC | DESC] ];

 

• Tweet
• Share
• Share
• Share
• Share

About Admin MC3

This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.

Related Post