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

Can another user execute your local temporary stored procedures?

964

What is the openxml statement in sql server?

1050

Explain different types of index?

1033

What is recompile sql server?

1017

What is the difference between ddl and dml?

1033

What does nvl stand for?

933

Which tcp/ip port does sql server run on? How can it be changed?

1017

How to call a function from a stored procedure in SQL Server ?

1002

Explain about SQL server 2005?

956

In what three ways is the return statement used in a stored procedure?

988

Explain the difference between functions and stored procedures in sql server?

961

What is difference between view and materialized view?

925

How to throw custom exception in Stored Procedure?

1023

What are transactions and its controls?

1042

What is the meaning of sql server?

974