how to find the second highest salary in a given table????
Answer Posted / shahnaz
To find the 2nd highest salary from emp table:
select max(sal) from emp where sal not in (select max(sal)
from emp )
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is the Tune Query
please explain.. DB architecture ...
Is it possible to insert comments into sql statements return in the data model editor ?
what is the scripts in data base?
Differentiate between post-database commit and post-form commit?
What privilege is needed for a user to delete rows from tables in another schema?
What are the different types of record groups in oracle? Explain each of them
Explain the blob datatype?
How to define a procedure inside another procedure?
6. Display the client name and order date for all orders using the traditional method.
What is meant by recursive hints in oracle?
How to change user password in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is user managed backup in Oracle?
What is PL/SQL ?