与“SELECT*FROM教师表INTO DBF A”等价的语句是______。
A:SELECT*FROM教师表TO DBF A B:SELECT*FROM教师表TO TABLE A C:SELECT*FROM教师表INTO TABLE A D:SELECT*FROM教师表INTO A
有SQL语句:
SELECT DISTINCT 系号 FROM 教师 WHERE 工资>=;
A:ALL (SELECT 工资 FROM 教师 WHERE 系号="02") B:与如上语句等价的SQL语句是( C:)。 SELECT DISTINCT 系号 FROM 教师 WHERE 工资>=; D:(SELECT MAX(工资) FROM 教师 WHERE 系号="02") E:SELECT DISTINCT 系号 FROM 教师 WHERE 工资>=; F:(SELECT MIN(工资) FROM 教师 WHERE 系号="02") G:SELECT DISTINCT 系号 FROM 教师 WHERE 工资>=;ANY (SELECT 工资 FROM 教师 WHERE 系号="02") H:SELECT DISTINCT 系号 FROM 教师 WHERE 工资>=; I:SOME (SELECT 工资 FROM 教师 WHERE 系号="02")
有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
DBMS的含义是( )。有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
与“SELECT*FROM 教师表 INTO DBFA”等价的语句是()。
A:SELECT*FROM 教师表 TO DBF A B:SELECT*FROM 教师表 TO TABLE A C:SELECT*FROM 教师表 INTO TABLE A D:SELECT*FROM 教师表 INTO A
与“SELECT * FROM 教师表 INTO DBF A”等价的语句是()。
A:SELECT * FROM 教师表 TO DBF A B:SELECT * FROM 教师表 TO TABLE A C:SELECT * FROM 教师表 INTO TABLE A D:SELECT * FROM 教师表 INTO A