Write a query to get all details of employee who has maximum
salary from employee table
- 8 Answers
- 14080 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
How to get the definition of a view out of the sql server?
Is foreign key unique?
What is a trace frag? Where do we use it?
How secure is sql server database?
What is query cost in sql server?
Can We Use Data-grids For Our Report In Ssrs?
What is Federation and Federation Member?
Differentiate between a having clause and a where clause.
What specific conditions database should meet, before you can bulk copy data into it using bcp?
What are date and time data types in ms sql server?
What are the different types of columns types constraints in the sql server?
How many types of triggers in sql server?
What is it unwise to create wide clustered index keys?
What is data set in report?
Can you tell me some of the common replication dmv's and their use? : sql server replication
