sample169.sql

来自「100多个SQL小程序,包含游标,基本增删改查,希望多你有用」· SQL 代码 · 共 14 行

/* 文件名称: Sample169.sql */
USE 北风贸易

SELECT TOP 3
       a.员工编号,
       a.姓名 AS 业务员姓名,
       SUM(c.单价 * c.数量*(1 - c.折扣)) AS 销售总金额
  FROM 员工 a
       INNER JOIN 订货主档 b ON a.员工编号 = b.员工编号
       INNER JOIN 订货明细 c ON b.订单号码 = c.订单号码
  GROUP BY a.员工编号,a.姓名
  ORDER BY 3 DESC