A. WHERE B. FROM C. VALUES D. SET
A. DELETE FROM book WHERE 单价>20 B. DELETE * FROM book C. DELETE FROM book HAVING 单价>20 DELETE FROM book
A. SELECT,INTO B. SELECT,FROM C. SELECT,GROUP D. 仅SELECT
A. DISTINCT B. UNION C. ALL D. TOP
A. SUM(*) B. COUNT(*) C. MAX(*) D. AVG(*)
A. WHERE H>60 AND H<100 B. WHERE H>=60 AND H<100 C. WHERE H>60 AND H<=100 D. WHERE H>=60 AND H<=100
A. % B. _ C. * D. ^
A. StName LIKE '张%' B. StName LIKE '张*' C. StName LIKE '张?' D. StName LIKE '张_'
A. 如果未指定排序字段,则默认按递增排序 B. 数据表的字段都可用于排序 C. 如果未指定DESC或ASC关键字,则默认按递增排序 D. ORDER BY子句不能按多个排序表达式进行排序
A. 将查询结果存入至StInfo中 B. 语句错误 C. 查询StInfo表中StId和StName字段信息,并将结果存入至new_info表中 D. 查询StInfo表中所有字段内容至new_info中