252.

The order by clause is added in a SQL statement? Select the best answer below

< SELECT statement> ::= 
[WITH [,...n]]

[ ORDER BY { order_by_expression | column_position [ ASC | DESC ] } 
[ ,...n ] ] 
[ COMPUTE 
{ { AVG | COUNT | MAX | MIN | SUM } ( expression ) } [ ,...n ] 
[ BY expression [ ,...n ] ] 
] 
[ ] 
[ OPTION ( [ ,...n ] ) ] 
::= 
{ | ( ) } 
[ { UNION [ ALL ] | EXCEPT | INTERSECT }
| ( ) [...n ] ] 
::= 
SELECT [ ALL | DISTINCT ] 
[TOP ( expression ) [PERCENT] [ WITH TIES ] ] 
< select_list > 
[ INTO new_table ] 
[ FROM { } [ ,...n ] ] 
[ WHERE ] 
[ ] 
[ HAVING < search_condition > ]