已知员工表emp(empno,ename,job,sal)其中empno员工编号,ename员工姓名,job员工的职位,sal员工的工资。若要查看工资大于2000的员工的信息,则正确的sql语句是()
A. select * from emp;
B. select * from emp where sal>2000;
C. select * emp where sal>2000 ;
D. select * from emp sal>2000;
下列sql语句能够正确执行的是()
A. select * from teacher where name in(test,test2);
B. select * from teacher where name (test,test2);
C. select * from
D. select * from teacher where name !=(test,test2);teacher where name not