Write a query to get all details of employee who has maximum
salary from employee table
- 8 Answers
- 14153 Views
- AON, Genpact, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What are the drawbacks of reporting in ssrs?
How do you manipulate data?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
What does it mean to manipulate data?
What can be used instead of trigger?
Explain the different index configurations a table can have?
How many database files are there in sql server 2000?what are they?
How can you tell if a database object is invalid?
Explain microsoft sql server functions?
Explain the steps to create and execute a user-defined function in the sql server?
How global temporary tables are represented and its scope?
What is the purpose of the master database?
Explain collation?
Can you pass expressions to stored procedure parameters?
How are the unique and primary key constraints different?
