How To select first row per group with condition

Question

I have the table named DealOffers :

I want to select only one record from each group of dealIds where Price is minimum.

i.e : the expected output should be like this:

if you can write the actual result and not the image that would be very helpful. — Dr. Stitch, Jun 20 '16 at 04:55
can you please post data in normal format not in image format — mohan111, Jun 20 '16 at 05:01

score 2 · Accepted Answer · answered Jun 20 '16 at 05:01

You can do something like this. However, you should consider performance if you end up having to do this on a massive scale.

select *
from (
    select *,
        SeqNum = row_number() over(
            partition by DealId
            order by Price)
    from DealOffers) do
where do.SeqNum = 1;

How To select first row per group with condition

1 Answers1