Unique records

[nuVBer]

I have a view that returns data that looks like this:

ID Comp_Sk
1 101
2 102
2 103
3 105

I want to return only the first, third and fourth rows. The duplicate record that has 102 as the Comp_Sk value of 102 should be eliminated from the select. I just want the largest value of the Comp_Sk field. What's the best way to do this?

 

[SQLBill]

Try this:

select id, max(comp_sk)
from view_name
group by id
order by id asc


-SQLBill

 

[essa2000]

Dear ;


Create table Test1
(PrimaryID [int] ,
Data [int]
)

insert into test1 (Primaryid , data) values (1, 100)
insert into test1 (Primaryid , data) values (2, 102)
insert into test1 (Primaryid , data) values (2, 103)
insert into test1 (Primaryid , data) values (3, 104)


Select PrimaryID , max(Data) from test1
Group by PrimaryID

Regards ,
Muhammad Essa Mughal