declare @temp table ( id int, val varchar(10))
insert into @temp
select 1,'a' union all
select 1,'b' union all
select 2,'c' union all
select 2,'d' union all
select 2, 'e' 

--select  * from @temp

select id,val
from 
( select id,val,row_number () over( partition by id order by val ) as rownum
 from @temp
)t 
where t.rownum = 1

quote:

---

Originally posted by amit.2601

Hi All,
i have table having two column A and B and having data as below

Column A Column B

1 w
1 x
2 y
2 z

I want to fetch record as below

Column A Column B
1 w
2 y

I want just one record against every value in column A from column B

Regards
Amit

---

SELECT COLA,COLB
FROM(
     SELECT COLA,COLB,ROW_NUMBER()OVER(PARTITION BY COLA ORDER BY COLB)AS SEQ
    )T WHERE SEQ=1