Breaking News: Grepper is joining You.com. Read the official announcement!

rank over if sql

Wide-eyed Wolf answered on May 30, 2024 Popularity 1/10 Helpfulness 1/10

answer rank over if sql

rank over if sql

Comment

SELECT Duns, ConfidenceCode, DeliveryAddressSeq, CustomerCode
FROM   (SELECT Duns, ConfidenceCode, DeliveryAddressSeq, CustomerCode,
               RANK() OVER (PARTITION BY duns
                            ORDER BY ConfidenceCode ASC,
                                     CASE DeliveryAddressSeq WHEN 0 THEN 0 
                                                             ELSE 1 
                                     END ASC,
                                     CustomerCode DESC) AS rk
        FROM   mytable)
WHERE  rk = 1

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: rank sql

Link to this answer
Share Copy Link