Select Distinct salary from employees e where &no-1=(select count(di

how to find the second highest salary from emp table?

Question Posted / yash goyal

Answer Posted / yash goyal

Select Distinct salary
from employees e
where &no-1=(select count(distinct salary )
from employees
where E.salary < salary);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are reports usually used for?

1019

What are the basic sql commands?

1086

Can we rollback delete command?

982

What are the advantages of pl sql?

1122

What is informix sql?

975

What is delimiter in pl sql?

1062

What are the possible values for the boolean data field?

961

What is multiple partition?

964

Why we use join in sql?

966

How many parts of a pl sql block are optional?

1128

What are the types pl/sql code blocks?

1123

What is a natural join?

1068

What is numeric function sql?

1056

What is pl sql collection?

963

What are joins in sql?

1044