Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get all details of employee who has maximum
salary from employee table
- 8 Answers
- 16741 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 is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How to find the source of a table in sql server?
What is instead of dml trigger?
What is normalization according to you and explain its different levels?
How to use old values to define new values in update statements in ms sql server?
What command is used to create a database in the sql server and how?
What is policy based management (pbm)? : sql server database administration
How to verify a user name with sqlcmd tool?
What is the difference between grant and with grant while giving permissions to the user?
How to search for a string in all stored procedure in sql server?
Can we write a distributed query and get some data which is located on other server and oracle database?
Difference between primary key and clustered index?
What are the differences between ms sql server & oracle?
How many databases can we create in a single server?
How to insert a new row into a table with "insert into" statements in ms sql server?
