DECLARE @t TABLE (name VARCHAR(20),

                  qy VARCHAR(20),

                  je INT);

INSERT INTO @t

SELECT '产品一',

       '北京',

       500

UNION ALL

SELECT '产品一',

       '上海',

       300

UNION ALL

SELECT '产品二',

       '北京',

       600

UNION ALL

SELECT '产品三',

       '上海',

       1000

UNION ALL

SELECT '产品三',

       '北京',

       8008

UNION ALL

SELECT '产品四',

       '上海',

       400;

SELECT *

  FROM @t;

SELECT *

  FROM @t a

 WHERE NOT EXISTS --这是取表中的NAME相同的最大值

 (SELECT 1 FROM @t WHERE name = a.name AND je > a.je);