用sql语句查询每个部门的最低工资的销售员姓名用嵌套查询涉及XSY表。销售数据库包括:XSY表销售员表MJ表买家表JY表交易表;XSY表中包含:Xno销售员号Xname姓名Xsex性别Office部门Fmoney工资;MJ表中包含:Mno买家号Mname买家姓名teleph手机;JY表中包含Mno买家号Xno销售员Fmoney交易金额Fdate交易日期
SELECT X1.Xname, X1.Office, MIN(X1.Fmoney) as MinSalary FROM XSY X1 WHERE X1.Office = '销售部' AND X1.Fmoney = (SELECT MIN(X2.Fmoney) FROM XSY X2 WHERE X1.Office = X2.Office) GROUP BY X1.Office, X1.Xname
原文地址: https://www.cveoy.top/t/topic/fjgx 著作权归作者所有。请勿转载和采集!