SELECT SALARY FROM (SELECT SALARY FROM emp WHERE ROWNUM

find out the second highest salary?

Question Posted / anand

Answer Posted / anand

SELECT SALARY FROM (SELECT SALARY FROM emp WHERE ROWNUM < 3
ORDER
BY salary) WHERE ROWNUM < 2

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain rename?

927

What is the fastest query method to fetch data from the table?

1297

IS it possible to built the oracle database without setting the kernal parameters?

2272

How do I find my oracle client driver version?

975

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1958

Explain the use of grant option in exp command.

1007

Explain the truncate in oracle?

915

Explain the different normalization forms?

1014

How to change program global area (pga) in oracle?

1034

What suggestions do you have to reduce the network traffic?

905

What are the built-in functions used for sending Parameters to forms ?

3311

How to convert csv to table in oracle?

925

What is blob datatype?

1059

How many memory layers are in the oracle shared pool?

1107

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2310