252.
The order by clause is added in a SQL statement? Select the best answer below
View Description
< 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 > ]