Friday, December 14, 2012 4:08 AM
I have table like
I just want like
CL1 should be unique. Only one record per distinct CL1 column.
I tried with different sub queries and all, they're not working. How to solve this problem.
Friday, December 14, 2012 4:43 AM
Pasupathi, Try as follows using CTE, this will work on SQL Server 2005 and above
Create table test(cl1 char(1), cl2 int) Insert into test values('A',1),('A',2),('A',3),('A',1),('B',11),('B',14) WITH temp AS ( SELECT *, ROW_NUMBER() OVER(PARTITION BY cl1 ORDER BY cl2) AS rn FROM test ) select cl1,cl2 from temp where rn=1
Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
Friday, December 14, 2012 4:45 AM
- Marked As Answer by Pasupathi Friday, December 14, 2012 4:46 AM