A.select count(*) from emp
B.select avg(*) from emp
C.select min(*) from emp
D.select max(*) from emp
A.select * from表名limit 0,3
B.select * from表名limit 3
C.select from表名limit 0,3
D.select * form表名limit 0,3
A.SELECT * FROM VIEW v_stu
B.SELECT * VIEW v_stu
C.SELECT * FROM v_stu
D.SELECT * FROM v_stu AS VIEW
A.SELECT * FROM Student ORDER BY age;
B.SELECT * FROM Student Group BY 'age';
C.SELECT * FROM Student ORDER BY 'age';
D.SELECT * FROM Student Group BY age;
A.select ename,nvl(comm.,0)from emp
B.select ename,null(comm.,0)from emp
C.SELECT ename,NULLIF(comm,0)FROM emp
D.SELECT ename,DECODE(comm.,NULL,0)FROM emp
A.dir mylog
B.select * from mylog
C.update * from mylog
D.Is mylog
A.在Oracle中运行" select instr(''abcdef'',''e'') from dual;"的结果是:4
B.在Oracle中运行"select rtrim(''abcdef'',''bc'') from dual; "的结果是:abcdef
C.在Oracle中运行" select replace(''a&a&b'',''&'',''-'') from dual;"的结果是:a-a-b
D.在Oracle中运行"select nvl2(null,2,3) from dual;"的结果是:3"
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.DECLARE@MyvarINT
B.SELECT*FROM[AAA]
C.CREATE DATABASE AAA
D.DELETE* FROM AAA