SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (

find out the second highest salary?

Question Posted / sikindar

Answer Posted / sikindar

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to convert times to characters in oracle?

981

How to rename an existing table?

1053

Why do you use stored procedures and state some of its disadvantages?

972

How can you merge two tables in oracle?

942

What is procedure overloading in oracle?

994

What is the simplest tool to run commands on oracle servers?

959

How to export your connection information to a file?

1077

How many file formats are supported to export data?

1139

How to create a new user account in oracle?

956

How to estimate disk space needed for an export job?

995

What is an oracle database?

991

How to install oracle database 10g xe?

968

What is a nested table?

1010

Explain the types of exception?

1083

Can the query output be sorted by multiple columns in oracle?

936