how to get second highest sal of emp table

Answer Posted / manjeet

select max(sal) from emp where sal not in (select max(sal)
from emp)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the general rules on data consistency?

742


How many types of database triggers exist?

743


How to test null values?

829


What are the most common interview questions on ETL Testing for experience?

828


Explain the use of record length option in exp command.

783






What is a database schema in oracle?

833


What is a select query statement in oracle?

707


What is user managed backup in Oracle?

813


What is a snapshot log?

751


How to convert a date to char in oracle? Give one example.

800


When system tablespace is created?

773


I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2048


Why oracle is used?

770


How to write a left outer join with the where clause in oracle?

823


How to create a stored program unit?

774