sql行变列求最大最小
859 ASX劲炫(进口) 19.80859 ASX劲炫(进口) 22.30859 ASX劲炫(进口) 23.30859 ASX劲炫(进口) 25.50859 ASX劲炫(进口) 18.38859 ASX劲炫(进口) 19.80859 ASX劲炫(进口) 20.80859 ASX劲炫(进口) 21.80859 ASX劲炫(进口) 23.98
WITH test (id,NAME,number) AS ( SELECT '859', 'ASX劲炫(进口)', 19.80 UNION ALL SELECT '859', 'ASX劲炫(进口)', 22.30 UNION ALL SELECT '859', 'ASX劲炫(进口)',23.30 UNION ALL SELECT '859', 'ASX劲炫(进口)', 25.50 UNION ALL SELECT '859', 'ASX劲炫(进口)', 18.38 UNION ALL SELECT '859', 'ASX劲炫(进口)', 19.80 UNION ALL SELECT '859', 'ASX劲炫(进口)', 20.80 UNION ALL SELECT '859', 'ASX劲炫(进口)', 21.80 UNION ALL SELECT '859', 'ASX劲炫(进口)', 23.98 ) SELECT id,name,MAX(number) [max],MIN(number)[min] FROM test GROUP BY id,name /* id name max min ---- ------------- --------------------------------------- --------------------------------------- 859 ASX劲炫(进口) 25.50 18.38 (1 行受影响) */
