sample186.sql

T-SQL示例大全

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

SELECT A.salesman,
              A.name,
              A.ytdsales,
              AVG(B.ytdsales) AS better
  FROM salesman A INNER JOIN salesman B
       ON A.ytdsales < B.ytdsales
  GROUP BY A.salesman,A.name,A.ytdsales
  ORDER BY A.ytdsales DESC