medium10 pts · first answer countswindow-functionssqlranking

Best seller per city with ties

Two stores in Dubai tie for the highest sales. Management wants both shown as joint winners. Which filter should you use?

A.RANK() OVER (PARTITION BY city ORDER BY sales DESC) = 1B.ROW_NUMBER() OVER (PARTITION BY city ORDER BY sales DESC) = 1C.NTILE(1) OVER (PARTITION BY city ORDER BY sales DESC) = 1D.LAG(sales) OVER (PARTITION BY city ORDER BY sales DESC) IS NULL

Discussion 0

Join free to post in the discussion.

Best seller per city with ties

Discussion 0

Related questions