在SQLServer中，现有产品表Products，包含字段：UnitPrice（商品单价），ProductId（产品编号），ProductName（商品名称），ProductClass（产品类别），从产品表Products中查询单价UnitPrice最高的商品单价，正确的SQL是（）

A.unique

B.default

C.heck

D.insert

A.CREATE

B.UPDATE

C.DELETE

D.INSERT

A.selecttop5*fromcourse

B.selecttop（5）fromcourse

C.selecttop5fromcourse

D.selecttop（5*）fromcourse

A.selectfirstname+'.'+lastnameas'name'fromemployee

B.selectfirstname+'.'+lastname='name'fromemployee

C.select'name'=firstname+'.'+lastnamefromemployee

D.selectfirstname,lastnamefromemployee

A.selectmax（price）fromdrink

B.selectmin（price）fromdrink

C.selectavg（price）fromdrink

D.selectsum（price）fromdrink

A.selectclassid,count（*）asnumfromshopgroupbyclassid

B.selectclassid,count（*）asnumfromshopgroupbyname

C.selectclassid,sum（*）asnumfromshopgroupbyaddress

D.selectclassid,sum（*）asnumfromshopgroupbyclassid

A.Fo×Pro

B.Access

C.Oracle

D.SQLServer

A.Mate9 Pro系列

B.P10系列

C.M10系列

A．Select stu_name from student_info where stu_grade=80 order by stu_id desc

B．Select stu_name from student_info where stu_grade=80 order by stu_id

C．Select stu_name from student_info where stu_grade like 80 group by stu_id

D．Select stu_name from student_info where stu_grade=80 order by stu_id asc