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

Is oracle the best database?

1010

11. Display the client number and name and the client number and name of the person who referred that client.

2390

What are the limitations oracle database 10g xe?

1093

What is the difference between translate and replace in oracle?

1217

How to filter out duplications in the returning rows using oracle?

1067

What are the predefined tablespaces in a database?

1141

What are the restrictions in a oracle read only transaction?

1082

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2166

What is dynamic proxy?

1052

What is the difference between translate and replace?

1118

What is integrity and what is constraint??Explain with example

2341

How to drop an existing view in oracle?

992

What is tns service name?

1178

What are the system predefined user roles?

1099

How to run create database statement?

1080