i have to list the most costly 10 locations. but if the cost of the 11th location is the same as 10th then i have to display 11 locations instead of 10. how can i do this?
Printable View
i have to list the most costly 10 locations. but if the cost of the 11th location is the same as 10th then i have to display 11 locations instead of 10. how can i do this?
Check out DENSE_RANK.