User517361227 posted
I tried this with case statement and it is returning desired result, but still need to confirm if that is good approach or there is any other better way to do it
SELECT
Id,
Name,
Score,
(CASE WHEN Score > 0 THEN RANK() OVER (ORDER BY Score DESC) END) AS Position
FROM Result
This returns Position as Null for score 0 or negative, but still is there any better approach to do the task or above is fine and does not hurt performance of query?
Thanks