How to retrieve 5th highest sal from emp table?

Answer Posted / vasu

select * from emp a where &nth in(select count(b.sal) from
emp b where b.sal<=a.sal);

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the relation of a user account and a schema?

613


ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

1743


Explain what does a control file contain?

607


Define oracle database

594


State the difference between a primary key and foreign key?

516






How many types of tables are there in oracle?

576


Can you assign multiple query result rows to a variable?

548


What happens if variable names collide with table/column names?

584


What is set operator oracle?

526


How to get last row id?

557


What privilege is needed for a user to delete rows from tables in another schema?

562


What is an oracle cursor variable?

607


Explain user account with reference to oracle.

531


What is an oracle database table?

594


Oracle

1849