你可能喜欢
多项选择题
A.Update grade set score=score+5
B.Update grade set score=score+5 where score>=55 or score <=60
C.Update grade set score=score+5 where score between 55 and 60
D.Update grade set score=score+5 where score >=55 and score <=60
多项选择题
A.select top 1 * from book order by price asc
B.select top 1 * from book order by price desc
C.select top 1 * from book where price= (select max (price)from book)
D.select top 1 * from book where price= max(price)
多项选择题
A.select max(score) from grade
B.select top 1 score from grade order by score asc
C.Select min(score) from grade
D.select top 1 score from grade order by score desc
多项选择题
A.01053090A#Hm3?
B.01003090A01
C.01053090D09
D.0101A01
多项选择题
A.Truncate table 可跟Where从句,根据条件进行删除
B.Truncate table 用来删除表中所有数据
C.触发器对Truncate table无效
D.delete 比Truncate table速度快
多项选择题
A.SELECT * FROM 学习经历 WHERE 毕业学校 LIKE ’*清华*’
B.SELECT * FROM 学习经历 WHERE 毕业学校 = ’清华%’
C.SELECT * FROM 学习经历 WHERE 毕业学校 LIKE ’?清华?’
D.SELECT * FROM 学习经历 WHERE 毕业学校 LIKE ’%清华%’
多项选择题
A.Select * from [order details] Order by quantity desc
B.Select * from [order details] Order by quantity asc
C.Select * from [order details] Order by quantity
D.Select * from [order details] Order by desc quantity
多项选择题
A.SELECT * FROM Products WHERE UnitPrice >= 20 OR UnitPrice <= 40
B.SELECT * FROM Products WHERE UnitPrice BETWEEN 20 OR 40
C.SELECT * FROM Products WHERE UnitPrice >= 20 AND UnitPrice <= 40
D.SELECT * FROM Products WHERE UnitPrice BETWEEN 20 AND 40
多项选择题
A.SELECT Product Name AS’产品的名称’,Unit Price AS’单价’FROM Products
B.SELECT Product Name=产品的名称,Unit Price=单价FROM Products
C.SELECT Product Name=“产品的名称”,Uni tPrice=“单价”FROM Products
D.SELECT Product Name’产品的名称’,Unit Price’单价’FROM Products