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
- 17053 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
Define the one-to-one relationship while designing tables.
How do I schedule a sql server profiler trace?
What are triggers in ms sql server?
Is the order of columns in the set clause important in ms sql server?
Where are SQL server users names and passwords are stored in sql server?
Is it possible to create trigger on views?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
How to backup encryption key ?
Explain the etl (extraction, transformation, and loading)?
What is the process of indexing?
What is the command dbcc checkdb used for?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What are some examples of schemas?
What is query cost in sql server?
What are basics of policy management?
