1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.
Answer Posted / neha k
select sal
from (SELECT sal, rownum row_num
FROM emp
order by sal desc)
where row_num = 2;
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How can we delete duplicate rows in a table?
How to create a new tablespace in oracle?
Explain alias?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
material view and view disadvantages?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What is oracle sid?
how may join possible between (requisition with purchase order)
Can we store pictures in the database and if so, how it can be done?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Can we commit inside a function in oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
How to put more than 1000 values into an oracle in clause?
What types of joins are used in writing subqueries?