Couple of different ways to get the highest density:select TOP (1) with ties name, 1.0*population/area as density
from country
order by density desc
;with cte as
(
select name, 1.0*population/area as density,
RANK() over(order by 1.0*population/area desc) as RNK
from country
)
select name, density from cte where RNK = 1;