Department wise highest salary

Department wise highest salary

CREATE TABLE [dbo].[emp](
[id] [int]  NULL,
[name] [varchar](20) NULL,
[city] [varchar] (20) NULL,
[dept] [varchar](10) NULL,
[salary] [money] NULL
)

insert into emp values(100,'Kishore','bangalore','IT',48000)
insert into emp values(101,'pavan','bangalore','HR',32000)
insert into emp values(102,'mahesh','pune','Slaes',24000)
insert into emp values(103,'harish','mumbai','IT',42000)
insert into emp values(104,'ramya','pune','HR',28000)
insert into emp values(105,'swetha','bangalore','Slaes', 26000)
insert into emp values(106,'sindhu','pune','IT', 34000)
insert into emp values(107,'naresh','mumbai','HR',30000)
insert into emp values(108,'kumar','mumbai','Slaes', 30000)
insert into emp values(109,'ashok','bangalore','IT', 42000)
insert into emp values(110,'siva','madanapalli','IT',36000)

                                                                   Actual table                                                                          

Required Result

Query:

Select id,name,city,dept,salary from
 (
           select id,name,city,dept,salary,
           DENSE_RANK() over(partition by dept order by salary                    desc) as drank from emp
) as kk
where drank=1