How to get employee name from employee table which is the
fiveth highest salary of the table
Answer Posted / kishore
select salery from (
(select salery ,rownum as num from
(select salery from employees order by salery desc)
where rownum <= 5 ))
where num = 5;
| Is This Answer Correct ? | 18 Yes | 4 No |
Post New Answer View All Answers
How do you get column names only for a table (sql server)?
How to pronounce postgresql?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
How many triggers can be applied to a table?
how many triggers are allowed in mysql table? : Sql dba
Is sql microsoft?
What is the location of pre_defined_functions.
What are the two types of periodical indexes?
How do I quit sql?
What is rank () in sql?
what is the use of set statement in tsql? : Transact sql
In what condition is it good to disable a trigger?
What is the best sql course?
What is index example?
How do you explain an index number?