Select * From (Select emp1.*, dense_rank () Over (Order By sal asc) Salar

An employee table, with the columns id, name, sal and dob.
Query to select emp names of all highest salaries(there are
4-5 people having the same salary which happens to be the
highest).

Question Posted / amol dhane

9 Answers
15808 Views
ADP, I also Faced
E-Mail Answers

Answer Posted / amol dhane

Select * From (Select emp1.*, dense_rank () Over (Order By
sal asc) Salary_Order From employee emp1)emp2 Where
Salary_Order = 1

Is This Answer Correct ?

10 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define union, union all, minus, intersect?

932

What are .mdf files?

885

Explain SSRS Architecture?

181

Tell me what is log shipping?

935

How many non clustered indexes there can be on table ?

860

Explain unique key in sql server?

952

What methods do you follow to protect from sql injection attack?

966

What are secondary xml indexes?

983

What do you understand by intent locks?

952

How does a profiler work?

870

what are the different stages of Report Processing?

125

What are the difference between primary keys and foreign keys?

913

Is null in sql server?

938

Can we install sql server 2016 on windows 7?

1071

What is change data capture (cdc) feature?

997