更多"有SQL语句:SELECT*FROM 职工表 WHERE NOT(工资"的相关试题:
[单项选择]有如下SQL语句:
SELECT DISTINCT 仓库号 FROM 职工表 WHERE 工资>=ALL;
(SELECT 工资 FROM 职工表 WHERE 仓库号="A1")
执行语句后,显示查询到的仓库号有
A. A1
B. A3
C. A1,A2
D. A1,A3
[单项选择]有SQL语句:SELECT*FROM 职工表 WHERE NOT(工资>2500 OR 工资<1800),与如上语句等价的SQL语句是______。
A. SELECT*FROM 职工表 WHERE 工资 BETWEEN 1800 AND 2500
B. SELECT*FROM 职工表 WHERE 工资>1800 AND 工资<2500
C. SELECT*FROM 职工表 WHERE 工资>1800 OR 工资<2500
D. SELECT*FROM 职工表 WHERE 工资<=1800 AND 工资>=2500
[单项选择]有如下SQL语句:
SELECT DISTINCT仓库号FROM职工表WHERE工资>=ALL;
(SELECT 工资 FROM 职工表 WHERE 仓库号=“A1”)
执行语句后,显示查询到的仓库号有
A. A1
B. A3
C. A1,A2
D. A1,A3
[单项选择]有下列SQL SELECT语句:
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. SELECT *FROM 工资表 WHERE 基本工资 FROM 3000 INTO 1000
[单项选择]有如下SQL SELECT语句:
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. SELECT*FROM工资表WHERE基本工资FROM 3000 INTO 1000
[单项选择]有如下SQL语句:
SELECT SUM(工资)FROM职工表WHERE仓库号IN;
(SELECT仓库号FROM仓库表WHERE所在城市="北京"OR所在城市="上海")
执行语句后,工资总和是
A. 1500.00
B. 3000.00
C. 5000.00
D. 10500.00
[单项选择]有如下SQL语句:
SELECT SUM(工资)FROM职工表WHERE仓库号IN;
(SELECT仓库号FROM仓库表WHERE所在城市=“北京”OR所在城市=“上海”)
执行语句后,工资总和是
A. 3500.00
B. 3000.00
C. 5000.00
D. 10500.00
[单项选择]
有SQL语句
SELECT * FROM 教师 WHERE NOT(工资>30000R工资<2000)
与如上语句等价的SQL语句是()。
A. SELECT * FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000
B. SELECT * FROM 教师 WHERE 工资>2000 AND工资<3000
C. SELECT * FROM 教师 WHERE 工资>2000 OR工资<3000
D. SELECT * FROM 教师 WHERE 工资<=2000 AND工资>=3000
[单项选择]有SQL语句:
SELECT*FROM教师WHERE NOT(工资>3000 OR工资<2000)
与如上语句等价的SQL语句是
A. SELECT*FROM教师WHERE工资BETWEEN 2000 AND 3000
B. SELECT*FROM教师WHERE工资>2000 AND工资<3000
C. SELECT*FROM教师WHERE工资>2000 OR工资<3000
D. SELECT*FROM教师WHERE工资<=2000 AND工资>=3000
[单项选择]有如下SQL-SELECT语句 SELECT*FROM HH WHERE 单价 BETWEEN 10.6 AND 13.4 与该语句等价的是
A. SELECT*FROM HH WHERE 单价 <=13.4 AND 单价 >=10.6
B. SELECT*FROM HH WHERE 单价 <13.4 AND 单价 >10.6
C. SELECT*FROM HH WHERE 单价 >=13.4 AND 单价 <=10.6
D. SELECT*FROM HH WHERE 单价 >13.4 AND 单价 <10.6
[单项选择]有如下SQL SELECT语句 SELECT*FORM 工资表 WHERE 基本工资<=2000 AND 基本工资>=1500 下列与该语句等价的
A. SELECT*FORM 工资表 WHERE 基本工资 BETWEEN 1500 AND 2000
B. SELECT*FORM 工资表 WHERE 基本工资 BETWEEN 2000 AND 1500
C. SELECT*FORM 工资表 WHERE 基本工资 FROM1500 INTO 2000
D. SELECT*FORM 工资表 WHERE 基本工资 FROM 2000 INTO 1500