Home Forums SQL Server 7,2000 T-SQL group by part of a multi column primary key RE: group by part of a multi column primary key

  • June 12, 2003 at 12:55 pm

    #461128

    Here's a quick solution:

    

    SELECT		t1.col1,

    		Max(t1.col2) col2

    INTO		#tmp

    FROM		t1

    GROUP BY	t1.col1

    

    SELECT		#tmp.col1,

    		#tmp.col2,

    		t1.col3

    FROM		#tmp

    		JOIN

    		t1

    		ON #tmp.col1 = t1.col1

    		AND #tmp.col2 = t1.col2

    

    DROP TABLE	#tmp

    --SJTerrill

    Edited by - TheWildHun on 06/12/2003 12:56:09 PM