查向所有目前年龄在35以上(不含35岁)的职工信息(姓名、性别和年龄)的正确的命令是______。A.SELECT 姓名,性别,YEAR (DATE()) -YEAR(出生日期)年龄 FROM 职工; WHERE 年龄>35B.SELECT 姓名,性别,YEAR (DATE()) -YEAR(出生日期)年龄 FROM 职工; WHERE YEAR (出生日期)>35C.SELECT 姓名,性别,YEAR (DATE())- YEAR (出生日期)年龄 FROM 职工; WHERE YEAR (DATE())- YEAR(出生日期)>35D.SELECT 姓名,性别,年龄=YEAR(DATE())- YEAR(出生日期)FROM 职工; WHERE YEAR(DATE())-YEAR (出生日期)>35
Tony: Eric has decided to quit drinking.David: Again? ______A、It's a difficult decision to make.B、Alcohol-addiction is dangerous.C、I wonder how long it will last this time.D、He's an alcohol addict.
查询所有目前年龄在35岁以上(不含35岁)的职工信息(姓名、性别和年龄),正确的命令是A.SELECT 姓名,性别,YEAR(DATE())-YEAR(出生日期)AS年龄FROM职工; WHERE年龄>35B.SELECT 姓名,性别,YEAR(DATE())-YEAR(出生日期)AS年龄FROM 职工; WHERE YEAR(出生日期)>35C.SELECT姓名,性别,YEAR(DATE())-YEAR(出生日期)AS年龄FROM 职工; WHEREYEAR(DATE())-YEAR(出生日期)>35D.SELECT姓名,性别,年龄:YEAR(DATE())-YEAR(出生日期)FROM 职工; WHERE YEAR(DATE())-YEAR(出生日期)>35
查询所有目前年龄是22岁的学生信息:学号,姓名和年龄,正确的命令组是( )。A.CREATE VIEW AGE LIST AS; SELECT 学号,姓名,YEAR(DATE())-YEAR(出生日期)年龄FROM学生; SELECT 学号,姓名,年龄FROM AGE LIST WHERE年龄=22B.CREATE VIEW AGE LIST AS; SELECT 学号,姓名,YEAR(出生日期) FROM 学生; SELECT 学号,姓名,年龄FROM AGE LIST WHERE YEAR(出生日期)=22C.CREATE VIEW AGE LIST AS; SELECT 学号,姓名,YEAR(DATE())-YEAR(出生日期)年龄FROM学生; SELECT 学号,姓名,年龄FROM学生WHEREYEAR(出生日期)=22D.CREATE VIEW AGE LIST AS STUDENT; SELECT学号,姓名,YEAR(DATE())-YEAR(出生日期)年龄FROM学生; SELECT学号,姓名,年龄FROM STUDENT WHERE年龄=22
查询所有目前年龄在35以上(不含35岁)的职工信息(姓名、性别和年龄)的正确的命令是A) SELECT姓名,性别,YEAR(DATE())-YEAR(出生日期)年龄FROM职工;WHERE年龄35B) SELECT姓名,性别,YEAR(DATE())-YEAR(出生日期)年龄FROM职工;WHERE YEAR(出生日期)35C) SELECT姓名,性别,YEAR(DATE())-YEAR(出生日期、年龄FROM职工:WHERE YEAR(DATE()-YEAR(出生日期35D) SELECT姓名.性别.年龄=YEAR(DATE())-YEAR(出生日期、FROM职工:WHERE YEAR(DATE())-YEAR(出生日期)35
可以正确查询所有目前年龄在35岁以上的职工信息(姓名、性别和年龄)的SQL SELECT命令是( )。A.SELECT姓名,性别,YEAR(DATE)-YEAR(出生日期)年龄FROM职工; WHERE年龄35B.SELECT姓名,性别;YEAR(DATE)-YEAR(出生日期)年龄FROM职工; WHERE YEAR(出生日期)35C.SELECT姓名,性别,年龄=YEAR(DATE)-YEAR(出生日期)年龄FROM职工; WHERE YEAR(DATE)-YEAR(出生日期)35D.SELECT姓名,性别,YEAR(DATE)-YEAR(出生日期)年龄FROM职工; WHERE YEAR(DATE)-YEAR(出生日期)35
查询所有目前年龄是22岁的学生信息:学号,姓名和年龄,正确的命令组是A.CREATE VIEW AGE_LIST AS; SELECT学号,姓名,YEAR(DATE())-YEAR(出生日期)年龄FROM学生; SELECT学号,姓名,年龄FROM AGE_LIST WHERE年龄=22B.CREATE VIEW AGE_LIST AS; SELECT学号,姓名,YEAR(出生日期)FROM学生: SELECT学号,姓名,年龄FROM AGE_LIST WHERE YEAR(出生日期)=22C.CREATE VIEW AGE_LIST AS; SELECT学号,姓名,YEAR(DATE())-YEAR(出生日期)年龄FROM学生; SELECT学号,姓名,年龄FROM学生WHERE YEAR(出生日期)=22D.CREATE VIEW AGE_LIST AS STUDENT; SELECT学号,姓名,YEAR(DATE()).YEAR(出生日期)年龄FROM学生; SELECT学号,姓名,年龄FROM STUDENT WHERE年龄=22
查询所有目前年龄在35以上(不含35岁)的职工信息(姓名、性别和年龄)的正确的命令是A.SELECT 姓名,性别,YEAR(DATE())-YEAR(出生日期)年龄 FROM 职工; WHERE 年龄>35B.SELECT 姓名,性别,YEAR(DATE())-YEAR(出生日期)年龄 FROM 职工; WHERE YEAR(出生日期)>35C.SELECT 姓名,性别,YEAR(DATE())-YEAR(出生日期)年龄 FROM 职工; WHERE YEAR(DATE())-YEAR(出生日期)>35D.SELECT 姓名,性别,年龄=YEAR(DATE())-YEAR(出生日期) FROM 职工; WUERE YEAR(DATE())-YEAR(出生日期)>35
查询所有目前年龄在25岁以下(不含25岁)的职工信息(姓名、性别和年龄),正确的命令是( )。A)SELECT姓名,性别,YEAR(DATE())-YEAR(出生日期)年龄FROM职工;WHERE年龄25B)SELECT姓名,性别,YEAR(DATE())-YEAR(出生日期)年龄FROM职工;WHERE YEAR(出生日期)25C)SELECT姓名,性别,YEAR(DATE())-YEAR(出生日期)年龄FROM职工;WHERE YEAR(DATE()).YEAR(出生日期)25D)SELECT姓名,性别,年龄=YEAR(DATE())-YEAR(出生日期)FROM职工;WHERE YEAR(DATE())一YEAR(出生日期)25
查询22天之内参加工作的记录,准则是________。A.< Date() –22B.Between Date() And Date() – 22C.> Date() –22D.Between # Date() And # Date() – 22