SELECT语句中,以下有关ORDER BY子句的叙述中不正确的是()
A、 ORDER BY子句可以对多个列进行排序
B、 SELECT语句中,ORDER BY只能单一列进行排序
C、 子查询中也可以使用ORDER BY子句
D、 在视图中可以使用ORDER BY子句
A、 ORDER BY子句可以对多个列进行排序
B、 SELECT语句中,ORDER BY只能单一列进行排序
C、 子查询中也可以使用ORDER BY子句
D、 在视图中可以使用ORDER BY子句
A、SELECT TOP3 FROM scroe ORDER BY math ASC B、SELECT TOP3 FROM scroe ORDER BY math DESC C、SELECT TOP3*FROM scroe ORDER BY math DESC D、SELECT TOP3*FROM scroe ORDER BY math ASC
A、A.select max(score) from grade B、B.select top 1 score from grade order by score asc C、C.Select min(score) from grade D、D.select top 1 score from grade order by score desc
A、select top 1 * from book order by price asc B、select top 1 * from book order by price desc C、select top 1 * from book where price= (select max (price)from book) D、select top 1 * from book where price= max(price)
A、SELECT—FROM—GROUP—WHERE—ORDER B、FROM--WHERE——GROUP——ORDER——SELECT C、FROM——WHERE——GROUP——SELECT——ORDER D、SELECT——FROM——WHERE——GROUP——ORDER
A、A.SELECT productname,price from products order by price ASC B、B.SELECT productname,price from products order by price DESC C、C.SELECT productname,price from products order by price D、D.SELECT productname and price from products order by price DESC