Answer - SELECT FROM Employee Emp1 WHERE (N-1) = ( SELECT COUNT(DISTINC

Write a query to get all details of employee who has maximum
salary from employee table

Question Posted / mithilesh gatole

Answer Posted / mithilesh gatole

Answer -

SELECT FROM Employee Emp1 WHERE (N-1) = ( SELECT COUNT(DISTINCT(Emp2.Salary)) FROM Employee Emp2
WHERE Emp2.Salary > Emp1.Salary)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Does a specific recovery model need to be used for a replicated database? : sql server replication

914

What is difference between views and tables?

914

How do we synchronize On-Premise SQL server with SQL Azure?

120

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

884

What is statement level trigger?

938

Can we update data in a view?

973

Where cross join is used?

905

What is sql server replication? : sql server replication

925

What are the purposes and advantages stored procedure?

890

What are approximate numeric data types in ms sql server?

1011

Explain transaction server isolation?

982

What is function of master database?

114

Explain the functionalities that views support?

1046

What is partition, how will you implement it? : sql server analysis services, ssas

994

What is the purpose of self join?

918