find out the third highest salary?
Answer Posted / hanumantha r challa
select * from emp a where &n=(select count(b.sal) from emp
b where b.sal>=a.sal);
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to create an oracle testing table?
Explain the types of exception?
What is a table index in oracle?
How do I know if oracle is installed on windows?
Explain how are indexes update?
What are the ways tablespaces can be managed and how do they differ?
How will you identify oracle database software release?
How can I introduce multiple conditions in like operator?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to delete a column in an existing table in oracle?
What is memory advisor in Oracle?
What is index-organized table in Oracle?
Explain database link?
Give the various rollback segment states.
How to connect ms access to oracle servers?