在关系数据库中，执行如下SQL语句：SELECT 工号,姓名,性别,工龄FROM 职工表 WHERE 工龄＞10 GROUP BY 性别 ORDER BY 工龄 DESC，其中WHERE子句的作用是（）

A.SELECT姓名，入校总分FROM学生表WHERE（入校总分＞ANY（SELECT入校总分FROM学生表WHERE性别=“女生”））AND性别=“男”

B.SELECT姓名，入校总分FROM学生表WHERE（入校总分＞（SELECTMIN（入校总分）FROM学生表WHERE性别=“女生”））AND性别=“男”

C.SELECT姓名，入校总分FROM学生表WHERE（入校总分＞ALL（SELECT入校总分FROM学生表WHERE性别=“女生”））AND性别=“男”

D.SELECT姓名，入校总分FROM学生表WHERE（入校总分＞（SELECTMAX（入校总分）FROM学生表WHERE性别=“女生”AND性别=“男”）

A.SELECTMin（Year（Date（））-Year（生日））AS年龄FROM职工WHERE性别=男

B.SELECTMin（Year（Date（））-Year（[生日]））AS年龄FROM职工WHERE[性别]="男"

C.SELECT年龄FROM职工WHEREMin（Year（Date（））-Year（生日））AND性别=男

D.SELECT年龄FROM职工WHEREMin（Year（Date（））-Year（[生日]））AND[性别]="男"

A、select count(*) from student_tb where sex = '男';

B、select sum(*) from student_tb where sex = '男';

C、select avg(*) from student_tb where sex = '男';

D、select max(*) from student_tb where sex = '男';

A．DELETE Publisher WHERE Publisher=’ 群众出版社’

B．DELETE FROM Publisher WHERE Publisher=’ 群众出版社’

C．DELETE FROM Publisher WHERE Publisher= 群众出版社

D．DELETE Publisher WHERE Publisher= 群众出版社

A．CREATE VIEW Em_view WHLIE SELECT 职工号,工资 FROM Employee

B．CREATE AS Em_view VIEW SELECT 职工号,工资 FROM Employee

C．CREATE VIEW Em_view AS SELECT 职工号,工资 FROM Employee

D．CREATE VIEW Em_view SELECT 职工号,工资 FROM Employee

A、Select * From Student

B、Select Name From Student

C、Select Name,Age,IDCard From Student

D、Select Name Age IDCard Sex From Student

A．Select* From Student Where Sex=’男’

B．Select* From Student Where Number NotIn（Select Number From Student Where Sex＜＞=’男’）

C．Select* From Student Where NumberIn（Select Numbe rFrom Student Where Sex=’男’）

D．Select* From Student Where Sex＜＞’男&rsquo

A．select*intocatt where from kehu

B．select*into catt from kehu

C．insert into catt select*from kehu

D．inser tinto catt from select*from kehu

A、Select * From Emp Where Len(Name)=10

B、Select * From Emp Where Length(Name)=5

C、Select * From Emp Where count(Name)=10

D、Select * From Emp Where sum(Name)=10