A select * from where deptno=1 or sal<300; B. select ename,hiredate,sal from emp; C. select * from emp order deptno; D. select * from where deptno=1 and sal<300;
A. select * from emp; B. select name,date,salary from emp; C. select * from emp orderid; D. select * from whereid=1 and salary<300;
A. SELECT Sno,SNAME FROM S WHERE SNAME=′_刘%′ B. SELECT Sno,SNAME FROM S WHERE SNAME LIKE′%刘%′ C. SELECT Sno,SNAME FROM S WHERE SNAME LIKE′_刘%′ D. 全部
A. SELECT Sno,SNAME FROM S WHERE SNAME=′王%′ B. SELECT Sno,SNAME FROM S WHERE SNAME LIKE′王% ′ C. SELECT Sno,SNAME FROM S WHERE SNAME LIKE′王_′ D. 全部
A. 在LIMIT子句中使用RAND()函数指定行数,并用ORDER BY子句定义一个排序规则 B. 只要使用LIMIT子句定义指定的行数即可,不使用ORDER BY子句 C. 只要在ORDER BY子句中使用RAND()函数,不使用LIMIT子句 D. 在ORDER BY子句中使用RAND()函数,并用LIMIT子句定义行数