多项选择题
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)
成绩表grade中字段score代表分数,以下()语句返回成绩表中的最低分。A.select max(scor...
多项选择题成绩表grade中字段score代表分数,以下()语句返回成绩表中的最低分。
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
Sql语句:select * from students where SNO like ‘010[^0]%[A...
多项选择题Sql语句:select * from students where SNO like ‘010[^0]%[A,B,C]%’,可能会查询出的SNO是()
A.01053090A#Hm3? B.01003090A01 C.01053090D09 D.0101A01
关于Truncatetable,以下()描述是正确的。A.Truncate table 可跟Where从句,根...
多项选择题关于Truncatetable,以下()描述是正确的。
A.Truncate table 可跟Where从句,根据条件进行删除 B.Truncate table 用来删除表中所有数据 C.触发器对Truncate table无效 D.delete 比Truncate table速度快