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
Should I use mbr or gpt?
Mention what plvcmt and plvrb does in pl/sql?
How does pl sql work?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What is sql server and ase?
What is aggregate function in sql?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is a left join?
What is dml with example?
What is clustered index sql?
How to place comments in pl/sql?
Explain the select statement in sql?
Can we join two tables without common column?
List the ways to get the count of records in a table?
Can pl sql procedure have a return statement?