sample186.sql

100多个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