The ORDER BY clause can only be used in

Related MCQs

• The              clause allows us to select only those rows in the result relation of the           clause that satisfy a specified predicate.
• What is the default order of Order by clause?
• If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ______________
• Using the              clause retains only one copy of such identical tuples.
• The UNION SQL clause can be used with _____________
• The predicate in a where clause can involve Boolean operations such as and. The result of true and unknown is               false and unknown is            while unknown and unknown is            
• The UPDATE SQL clause can _____________
• The                  clause is used to list the attributes desired in the result of a query.
• SQL applies predicates in the                 clause after groups have been formed, so aggregate functions may be used.
• The                  keyword is used to access attributes of preceding tables or subqueries in the from clause.