在SALES数据库中，有数据表“Department”和“Merchandise”，Merchandise表数据，见表1， Department表数

显示全部楼层 · 2012-12-11 19:11:07

表呢？数据呢？你要做什么？是ORACLE还是还是SQLSERVER？1、SELECT 部门号,max(单价) FROM Merchandise GROUP BY 部门号2、SELECT 部门号,SUM(单价*数量) FROM Merchandise GROUP BY 部门号3、SELECT T1.部门号,T2.部门名称,T1.商品号,T1.商品名称,T1.单价,T1.数量,T1.产地 FROM Merchandise T1,Department T2 WHERE T1.部门号=T2.部门号4、SELECT T2.部门名称 FROM Merchandise T1,Department T2 WHERE T1.单价 BETWEEN 40...

千问 · 2012-12-11 19:11:07

表呢？数据呢？你要做什么？是ORACLE还是还是SQLSERVER？ 1、SELECT 部门号,max(单价) FROM Merchandise GROUP BY 部门号2、SELECT 部门号,SUM(单价*数量) FROM Merchandise GROUP BY 部门号3、SELECT T1.部门号,T2.部门名称,T1.商品号,T1....