A、指定查询的表
B、给出查询结果的顺序
C、限定查询的条件
D、说明查询的字段
更多“在SELECT命令中，ORDER BY的主要功能是（）”相关的问题
A、Select * from [order details] Order by quantity desc B、Select * from [order details] Order by quantity asc C、Select * from [order details] Order by quantity D、Select * from [order details] Order by desc quantity
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 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
A、select top3 cDiscription fromTvtype order by iprice asc B、select cDiscription from Tvtype where max（iprice）>3 C、select top3 cDiscription from Tvtype order by iprice desc D、selec tcDiscription max（iprice）from Tvtype order by iprice
A、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ）； B、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ） WHERE ROWNUM<=3； C、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY DESC） WHERE ROWNUM<=3； D、SELECT * FROM EMPLOYEES WHERE ROWNUM<=3 ORDER BY SALARY DESC；
客服
TOP
查看正确答案
