shouldnt it be the belowSELECT Col1, col2, col3FROM (SELECT Col1, col2, MAX(col3) OVER (PARTITION BY Col1,COl2) AS Col3, ROW_NUMBER() OVER(PARTITION BY Col1,COl2 ORDER BY col3) RNFROM Table) tWHERE t.RN = 1
check with this sample datacol1 col2 col3AAA A01 helloAAA A01AAA A02 hiAAA A02 BBB B01CCC C01DDD D01
what should be your output?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs