what is the query to return Name and Salary of employee Having Max Salary

Question

1. what is the query to return Name and Salary of employee Having Max Salary

Answer 1

Select e.name, e.salary from employee e where
  not exists (select salary from employee e1 where e.salary < e1.salary)

This will of course return more than one record if there are multiple people with the max salary.

Answer 2

SELECT Name, Salary FROM Minions
WHERE Salary = (SELECT Max(Salary) FROM Minions)

Answer 3

set rowcount 1 select name, salary from employees order by salary desc

or

select name, salary from employees where salary=max(salary)

Of course this could be dependant on type of sql (which you didn't supply), column names (which you didn't supply), table names (which you didn't supply)...

So...take that for what it's worth.

Answer 4

select name, salary from (select * from salary_table order by salary desc limit 1)

Answer 5

A couple of proprietary solutions

SELECT TOP 1 [WITH ties] Name, Salary
FROM employee
ORDER BY  Salary DESC


SELECT Name, Salary
FROM employee
ORDER BY  Salary DESC
LIMIT 1

And a standard one

WITH E AS
(
    SELECT Name, Salary, 
    ROW_NUMBER() OVER (ORDER BY Salary DESC) RN /*Or RANK() for ties*/
    FROM employee
)
SELECT Name, Salary FROM E WHERE RN=1