How to get employee name from employee table which is the
fiveth highest salary of the table
Answer Posted / avi007
SELECT employee_name,min(salary) FROM ( select distinct
salary from employee order by salary desc)
where rowno<6 group by employee_name;
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
how to return query output in html format? : Sql dba
how to check server status with 'mysqladmin'? : Sql dba
Is left join faster than join?
How do I create a sql database?
What is normalization sql?
What is crud stand for?
What are triggers in sql?
Does truncate release storage space?
What is on delete restrict?
Explain spool.
What are the different parts of a package?
What is dcl in sql?
What is use of term?
What are actual parameters and formal parameters?
how does a local variable is defined using t-sql? : Transact sql