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
Mention what plvcmt and plvrb does in pl/sql?
How to read/write files from pl/sql?
How much does sqlite cost?
How do you define a foreign key?
Describe different types of general function used in sql?
what is 'mysqld'? : Sql dba
Explain 3 basic parts of a trigger.
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
How many types of triggers exist in pl/sql?
Define SQL and state the differences between SQL and other conventional programming Languages?
What is a sql*loader control file?
What is bulk compiling in pl/sql.?
How many types of normalization are there?
how would concatenate strings in mysql? : Sql dba
Which one is faster ienumerable or iqueryable?