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 > ]