SELECT * FROM (SELECT salary FROM emp ORDER BY salary DESC) WHERE ROWNUM<

find out the second highest salary?

Question Posted / elumalai d

55 Answers
87703 Views
Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
E-Mail Answers

Answer Posted / elumalai d

SELECT * FROM (SELECT salary FROM emp ORDER BY salary DESC) WHERE ROWNUM<3;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain view?

977

What privilege is needed for a user to create tables in oracle?

900

What is meant by recursive hints in oracle?

1025

what are bitmap indexes? How does they work?

2181

query optmization techniques and quwry analyser+projects+ppts

2369

Difference between the “verify” and “feedback” command?

1308

Give the various exception types.

942

When do I need to use a semicolon vs a slash in oracle sql?

1025

What is open database communication (odbc) in oracle?

947

Explain user account with reference to oracle.

926

What is the usage of synonyms?

1059

List the various oracle database objects?

993

How would you begin to troubleshoot an ORA-3113 error?

2022

What is a tns file?

937

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2412