SELECT * FROM (SELECT ROWNUM sl, salary FROM (SELECT DISTINCT

how to find the second highest salary in a given table????

Question Posted / mahesh

Answer Posted / mahesh

SELECT *
FROM (SELECT ROWNUM sl, salary
FROM (SELECT DISTINCT salary
FROM employees
ORDER BY salary))
WHERE sl = n

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is sharded cluster?

1019

Explain coalesce function?

1210

How to store pictures on to the database?

980

How to define an external table with a text file?

1076

How to calculate date and time differences in oracle?

1045

Explain the different normalization forms?

1111

What do you mean by redo log file mirroring?

1037

what are actual and formal parameters?

1107

What is ordinary table in oracle?

1163

What is object data modeling?

970

How to resolve name conflicts between variables and columns?

1035

What are the differences between lov and list item?

1074

Where is the export dump file located?

1163

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2270

What is the relation of a user account and a schema?

1134