select salary from emp e where &n-1=(select count(*) from emp where s

how to find the second highest salary from emp table?

Question Posted / raghavendraprasad

Answer Posted / raghavendraprasad

select salary from emp e where &n-1=(select count(*) from
emp where salary>e.salary);

Is This Answer Correct ?

7 Yes

15 No

Please Help Members By Posting Answers For Below Questions

what are the different type of sql's statements ? : Sql dba

927

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1233

Are there any features that are decommissioned in 11g that are not present in 11g?

2150

Explain commit, rollback and savepoint.

1006

how to write date and time literals? : Sql dba

969

Describe different types of general function used in sql?

1042

What is snowflake sql?

1079

What program will open a mdb file?

970

What is sql exception?

977

What is execution plan in sql?

1053

Explain aggregate functions are available there in sql?

1012

What is the reports view in oracle sql developer?

998

Does sap use sql?

997

Is sql developer case sensitive?

1005

What are different functions in sql?

951