Where is Kate?- __________.
A.She's in Englan
B.She's from London.
C.She's a nurse in Englan
D.She is English
A.She's in Englan
B.She's from London.
C.She's a nurse in Englan
D.She is English
A.SELECT*FROM R WHERE L<'2'
B.SELECT LJ FROMR WHERE I<'2'
C.SELECT LJ FROMR WHERE J<'2'
D.SELECT* FROMR WHERE '5'<'2'
A.SELECT…FROM…ORDER BY
B.SELECT…WHERE…GROUP BY
C.SELECT…WHERE…HAVING
D.SELECT…FROM…WHERE
A.WHERE职工号=负责人
B.WHERE职工号='负责人'
C.WHERE姓名=负责人
D.WHERE姓名='负责人'
下面SELECT语句语法正确的是()。
A.SELECT*FROM'通信录'WHERE性别='男'
B.SELECT*FROM通信录WHERE性别='男'
C.SELECT*FROM'嗵信录'WHERE性别=男
D.SELECT*FROM通信录WHERE性别二男
A.SELECT*FROM学生; WHERE 年龄>(SELECT 年龄 FROM学生; WHERE 姓名=“孙静”)
B.SELECT*FROM学生; WHERE 姓名=“孙静”
C. SELECT*FROM 学生: WHERE 年龄>(SELECT 年龄; WHERE 姓名=“孙静”)
D.SELECT*FROM 学生: WHERE 年龄>“孙静”
A.SELECT城市FROM仓库WHERE仓库号 IN; SELECT仓库号FROM职工WHERE年龄>60
B.SELECT城市FROM仓库WHERE仓库号 IN; (SELECT仓库号FROM职工WHERE年龄>60)
C.SELECT仓库号FROM职工WHERE年龄>60 IN; SELECT城市FROM仓库WHERE仓库号
D.SEIECT仓库号FROM职工WHERE年龄>60IN; (SELECT城市FROM仓库WHERE仓库号)
有SQL语句:SELECT * FROM 教师 WHERE NOT(工资>3000 OR 工资<2000)与如下语句等价的SQL语句是A)SELECT*FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000B) SELECT*FROM 教师 WHERE 工资>2000 AND 工资<3000C)SELECT*FROM 教师 WHERE 工资>2000 OR 工资<3000D) SELECT*FROM 教师 WHERE 工资<=2000 AND 工资>3000
A.SELECT图书编号FROM读者,借阅WHERE职称=“工程师”
B.SELECT图书编号FROM读者,图书WHERE职称=“工程师”
C.SELECT图书编号FROM借阅WHERE图书编号=(SELECT图书编号FROM借阅WHERE职称=“工程师”)
D.SELECT图书编号FROM借阅WHERE借节证号IN(SELECT借书证号FROM读者WHERE职称=“工程师”)
有下列SQLSELECT语句:
SELECT*FROM 工资表 WHERE 基本工资<=3000 AND 基本工资>=1000
下列与该语句等价的是()。
A.SELECT*FROM 工资表 WHERE 基本工资 BETWEEN 1000 AND 3000
B.SELECT*FROM 工资表 WHERE 基本工资 BETWEEN 3000 AND 1000
C.SELECT*FROM 工资表 WHERE 基本工资 FROM 1000 INTO 3000
D.SEIECT*FROM 工资表 WHERE 基本工资 FROM 3000 INTO 1000