更多"[单选题]现有产品表Products，包含字段：UnitPrice（商"的相关试题:
[单选题]现有产品表Product，包含字段price（价格），productName（产品名称），cateId（分类编号），以下哪条SQL是查询每个分类的产品总数（）。
A.select cateId 产品分类,count(productName) 产品数量 from Product group by cateId
B.select cateId 产品分类,sum(productName) 产品数量 from Product group by cateId
C.select cateId 产品分类,count(productName) 产品数量 from Product group by productName
D.select cateId 产品分类,max(productName) 产品数量 from Product group by cateId
[单选题]现有书目表book，包含字段：价格price (float)，类别type(char); 现在查询各个类别的平均价格、类别名称，以下语句正确的是（选一项）
A.select avg(price),type from book group by type
B.select count(price),type from book group by price
C.select avg(price),type from book group by price
D.select count (price),type from book group by type
[单选题]现有书目表book，包含字段：price (float); 现在查询一条书价最高的书目的详细信息，以下语句正确的是（选一项）
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
D.select top 1 * from book where price= max(price)
[单选题]现有书目表book，包含字段：价格price ,类别名称typeName; 现在查询各个类别的平均价格、类别名称，以下语句正确的是（）。
A.select avg(price),type from book group by typeName
B.select count(price),type from book group by typeName
C.select avg(price),type from book group by typeName
D.select count (price),type from book group by typeName
[单选题]现有手机表Phone，包含字段：p_price（手机价格），p_id（手机编号），p_brand（手机品牌），计算每个品牌的手机数量，正确的SQL是（）。
A.SELECT p_brand,COUNT(p_id) FROM Phone GROUP BY p_id
B.SELECT p_brand,COUNT(p_id) FROM Phone GROUP BY p_brand
C.SELECT p_brand,COUNT(p_id) FROM Phone GROUP BY p_price
D.SELECT p_brand,COUNT(p_id) FROM Phone ORDER BY p_brand
[单选题]现有分数表score，包含字段：s_id(编号),c_id(科目编号),s_score(分数),哪条SQL（）可以正确查询查询平均成绩大于60分的学生的学号和平均成绩
A.SELECT s_id,AVG(s_score)
FROM score
GROUP BY s_id
HAVING AVG(s_score)>60;
B.SELECT s_id,AVG(s_score)
FROM score
GROUP BY s_id
AND AVG(s_score)>60;
C.SELECT s_id,AVG(s_score)
FROM score
ORDER BY s_id
HAVING AVG(s_score)>60;
D.SELECT s_id,AVG(s_score)
FROM score
GROUP BY c_id
HAVING AVG(s_score)>60;
[多选题]现有图书表book，包含字段：price(decimal(6,2));现查询书价最高的图书信息，正确语句是（）。【选两项】
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=max(price)
D.select top 1 * from book where price=(select max(price) from book)
[单选题]现有教师表teacher，包含字段:t_id(教师编号)，t_name(教师姓名),下列哪条SQL（）可以正确查询姓“王”的老师的个数
A.SELECT SUM(t_id)
FROM teacher t
WHERE t_name LIKE '王%'
B.SELECT COUNT(t_id)
FROM teacher t
WHERE t_name LIKE '王%'
C.SELECT COUNT(t_id)
FROM teacher t
WHERE t_name = '王%'
D.SELECT COUNT(t_id)
FROM teacher t
WHERE t_name LIKE '王_'
[单选题]现有课程表course，包含字段：c_id（课程编号），c_name（课程名称），c_date（开课日期），查询course表中的前5行，正确的语法是（）。
A.select top 5 * from course
B.select top(5) from course
C.select top 5 from course
D.select top(5*) from course
[单选题]现有汽车销售表c_orders，包含字段：c_id（订单编号），c_date（订单日期），c_price（订单金额），c_customer（客户姓名）,可以查找每个客户总金额的是（）。
A.SELECT c_customer,SUM(c_price) FROM c_orders
GROUP BY c_customer
B.SELECT c_customer,SUM(c_price) FROM c_orders
GROUP BY c_id
C.SELECT c_customer,COUNT(c_price) FROM c_orders
GROUP BY c_customer
D.SELECT c_customer,SUM(c_price) FROM c_orders
Order BY c_customer
[单选题]从产品表Products中查询前10行商品的单价UnitPrice之和，正确的SQL是（）。
A.SELECT TOP 10 SUM(UnitPrice) AS 单价之和 FROM Products
B.SELECT SUM(UnitPrice) AS 单价之和 TOP 10 FROM Products
C.SELECT TOP 10 COUNT(UnitPrice) AS 单价之和 FROM Products
D.SELECT SUM(UnitPrice) TOP 10 AS 单价之和FROM Products
[单选题]在SQL Server 2005中,学生表student中包含字段: 学生编号sid(主键),学生姓名sName, 现在查询所有姓名重复的记录,以下语句正确的是（选一项）
A.select * from student where count(sid)>1
B.select a. * from student a,student b where a.sname=b.sname
C.select * from student where count(sid)>1 group by sName
D.select * from student group by sName having count(sid)>1
[单选题]在SQL Server 2005中，有一个product(产品)表，包含字段：pname(产品名称)，要从此表中筛选出产品名称为“苹果”或者“香蕉”的记录，下列语句正确的是（选一项）
A.SELECT * FROM product ON pname= '苹果' OR pname='香蕉'
B.SELECT * FROM product ON pname= '苹果' AND pname='香蕉'
C.SELECT * FROM product WHERE pname= '苹果' OR pname='香蕉'
D.SELECT * FROM product WHERE pname= '苹果' AND pname='香蕉'
[单选题]SQLServer2005中, 有一个book(图书)表,包含字段:bookID(图书编号),title(书名), pDate(出版日期), author (作者) 等字段, 其中( )字段作为该表的主键是最恰当的（选一项）
A.bookID
B.title
C.pDate
D.author
[单选题]在SQL Server 2005中，假定grade(成绩)表中包含字段：sID(学号)，lang(语文课成绩)。那么列出语文成绩在80分到90分的学生的SQL语句是（选一项）
A.SELECT * FROM grade WHERE lang IN (80,90)
B.SELECT * FROM grade HAVING lang IN (80,90)
C.SELECT * FROM grade WHERE lang BETWEEN 80 AND 90
D.SELECT * FROM grade HAVING lang BETWEEN 80 AND 90
[单选题]在SQL Server 2005中，假定grade(成绩)表中包含字段：sID(学号),cID(班级编号)，lang(语文课成绩)，math(数学课成绩),那么先按班级，后按语文成绩排序的SQL语句是（选一项）
A.SELECT * FROM grade GROUP BY lang,cId
B.SELECT * FROM grade GROUP BYcId,lang
C.SELECT * FROM grade ORDER BY lang,cld
D.SELECT * FROM grade ORDER BY cId,lang
[单选题] 在SQL Server 2005中, 有students (学生)表, 包含字段: STD(学号),SName (姓名), Grade (成绩). 现查找所有学员中成绩最高的前5名学员. 下列SQL语句正确的是（选一项）
A.SELECT TOP 5 FROM students ORDER BY Grade DESC
B.SELECT TOP 5 FROM students ORDER BY Grade
C.SELECT TOP 5 * FROM students ORDER BY Grade ASC
D.SELECT TOP 5 * FROM students ORDER BY Grade DESC
[单选题]在SQL Server 2005中，有一个course(课程)表，包含字段：cName(课程名称)，grade(学分)。要从此表中查询所有学分不在２～４之间的课程名称，以下spl语句正确的是（选一项）
A.SELECT cName FROM course WHERE grade IN (2, 4)
B.SELECT cName FROM course WHERE grade NOT BETWEEN 2 AND 4
C.SELECT cName FROM course WHERE ! (grade > 2 AND grade < 4)
D.SELECT cName FROM course WHERE ! (grade < 2 OR grade <= 4)
[单选题]在SQL Server 2005中，假定grade (成绩)表中包含字段：sID(学号)，cID (班级编号)、lang(语文课成绩)、math(数学课成绩),那么计算所有学生人数和各科最高成绩的SQL语句是（选一项）
A.SELECT COUNT(*),MAX(lang),MAX(math)FROM grade
B.SELECT COUNT(*),MAX(lang),MAX(math)FROM grade GROUP BY sID
C.SELECT SUM(*),MAX(lang),MAX(math)FROM grade GROUP BY sID
D.SELECT SUM(*),MAX(lang),MAX(math)FROM grade
