select * from emp e where (select count(*) from emp where sal>=e.sal)=&a

how to find the second highest salary from emp table?

Question Posted / aravind naidu

Answer Posted / aravind naidu

select * from emp e where (select count(*) from emp where sal>=e.sal)=&n; put n = 2 for second highest sal,n = 3 for third highest sal ....and so on.

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is the difference between union and union all? : Sql dba

1020

How many developers work on postgresql?

984

What is the difference between inner join and left join?

989

What does pragma mean?

1056

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

926

What is asqueryable?

974

Why schema is used in sql?

1050

How long will it take to learn pl sql?

936

What is a temporal data type?

1052

How do I debug a stored procedure?

1114

how to get a list of columns in an existing table? : Sql dba

966

What is the clause we need to add in function body to return variable?

1012

Explain what is sql?

1119

What is sql not null constraint?

1038

What is trigger types of trigger?

1070