以下关于select查询中的order by子句,说法错误的是()
A.order by是对查询结果进行排序,因此一般最后执行
B.order by要与top 语句一起使用才可以
C.order by 1是正确而用法,表示按查询结果中第一列排序
D.order by子句后不跟asc或者desc时,默认升序
B、order by要与top 语句一起使用才可以
A.order by是对查询结果进行排序,因此一般最后执行
B.order by要与top 语句一起使用才可以
C.order by 1是正确而用法,表示按查询结果中第一列排序
D.order by子句后不跟asc或者desc时,默认升序
B、order by要与top 语句一起使用才可以
A.ORDER BY子句可以对多个列进行排序
B.在SELECT语句中,ORDER BY只能在所有其他子句之后,作为最后一个子句出现
C.子查询也可以使用ORDER BY子句
D.在视图中不能使用ORDER BY子句
A.SELECT命令中必须有FROM关键字
B.SELECT命令中必须有WHERE关键字
C.SELECT命令中必须有GROUP关键字
D.SELECT命令中必须有ORDER关键字
A.SELECT姓名TOP 2 EROM成绩表WHERE物理 DESC
B.SEl.ECT姓名TOP 2 FROM成绩表FOR物理DFAKC
C.SELECT姓名TOP 2 FROM成绩表GROUP BY物 理DESC
D.SELECT姓名TOP 2 FROM成绩表ORDER BY物 理DESC
A、SELECT CustomerName, SalesDate FROM Sales ORDER BY CustomerName, SalesDate
B、SELECT CustomerName, SalesDate FROM Sales ORDER BY SalesDate DESC, CustomerName
C、SELECT CustomerName, SalesDate FROM Sales ORDER BY CustomerName, SalesDate DESC
D、SELECT CustomerName, SalesDate FROM Sales ORDER BY CustomerName DESC
A.select max(score) from grade
B.select min(score) from grade
C.select top 1 score from grade order by score desc
D.select top 1 score from grade order by score asc
A.select ename,job,sal from emp where sal in(select avg(sal) from emp group by deptno)
B.select ename,job,sal from emp where sal in(select min(sal) from emp order by deptno)
C.select ename,job,sal from emp where sal in(select min(sal) from emp group by deptno)
D.select ename,job,min(sal) from emp where sal group by deptno
A.uid|course_id='251314'
B.uid='thinkphp'ANDcourse_id<>'251314'
C.uid='thinkphp'ANDcourse_id='251314'
D.uid='thinkphp'ORcourse_id='251314'
A.SELECT ename, sal FROM EMP
B.SELECT ename,sal, sal+100 FROM emp
C.SELECT ename,sal,12*sal+100 FROM emp
D.SELECT ename,sal,12*(sal+100)FROM EMP
A.SELECT * FROM stud ORDER BY birthday DESC LIMIT 8;
B.SELECT * FROM stud ORDER BY birthday ASC LIMIT 8;
C.SELECT * FROM stud ORDER BY birthday ASC LIMIT 7;
D.SELECT * FROM stud ORDER BY birthday DESC LIMIT 7;
A.select email from student where email not is null
B.select email from student where email !=null
C.select email from student where email is not null
D.select email from student where email <> null