以下用法中正确的是（） A: ARS = conn.Execute（“SELECT *FORM product”） B: BSet RS = conn.Execute （“SELECT *FORM product”） C: CConn.Execute （“DELETE *FORM product WHERE ID=132”） D: DConn.Ececute “DELETE *FORM product WHERE ID=132”

公告：维护QQ群：833371870，欢迎加入！
公告：维护QQ群：833371870，欢迎加入！
公告：维护QQ群：833371870，欢迎加入！

2022-06-11

以下用法中正确的是（） A: ARS = conn.Execute（“SELECT FORM product”） B: BSet RS = conn.Execute （“SELECT FORM product”） C: CConn.Execute （“DELETE FORM product WHERE ID=132”） D: DConn.Ececute “DELETE FORM product WHERE ID=132”

以下用法中正确的是（）
A: ARS = conn.Execute（“SELECT *FORM product”）
B: BSet RS = conn.Execute （“SELECT *FORM product”）
C: CConn.Execute （“DELETE *FORM product WHERE ID=132”）
D: DConn.Ececute “DELETE *FORM product WHERE ID=132”

答案：

查看

举一反三

检索选修课程"C2”的学生中成绩最高的学生的学号，正确的SELECT语句是______。 A: SELECT S# FORM SC WHERE C#="C2"AND GRADE＞=(SELECT GRADE FORM SC WHERE C#="C2") B: SELECT S# FORM SC WHERE C#="C2"AND GRADE IN(SELECT GRADE FORM SC) WHERE C#="C2" C: SELECT S# FORM SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2") D: SELECT S# FORM SC WHERE C#="C2"AND GRADE＞=ALL(SELECT GRADE FORM SC WHERE C#="C2")
在SQL Server 数据库中，从product表里查询出price（价格）高于pName（产品名称）为“一次性纸杯”所有记录中最高价格的产品的查询语句为（）。 A: SELECT * FROM product WHERE max(price)>'一次性纸杯' B: SELECT * FROM product WHERE price>(SELECT max(*) FROM product WHERE pName= '一次性纸杯') C: SELECT * FROM product WHERE EXISTS pName='一次性纸杯' D: SELECT * FROM product WHERE price>(SELECT max(price) FROM product WHERE pName='一次性纸杯')
The packaging, brand, quality and style of the material products belongs to ( ). A: core product layer B: potential product layer C: form product layer D: additional product layer
检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是( )。 A: SELECT S B: FORM SC WHERE C C: ='C2' AND GRAD>= (SELECT GRADE FORM SC WHERE C D: ='C2') E: SELECT S F: FORM SC WHERE C G: ='C2' AND GRADE IN (SELECT GRADE FORM SC WHERE C H: ='C2') I: SELECT S J: FORM SC WHERE C K: ='C2' AND GRADE NOT IN (SELECT GRADE FORM SC WHERE C L: ='C2') M: SELECT S N: FORM SC WHERE C O: ='C2' AND GRADE>=ALL (SELECT GRADE FORM SC WHERE C P: ='C2')
‏检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是（）。‍ A: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE >= ( SELECT GRADE FORM SC WHERE CNO='C2' ); B: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE IN ( SELECT GRADE FORM SC WHERE CNO='C2' ); C: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE NOT IN ( SELECT GRADE FORM SC WHERE CNO='C2' ); D: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE >= ALL ( SELECT GRADE FORM SC WHERE CNO='C2' );