SQL> select * from emp where sal=(select max(sal) from emp 2 where s

how to get second highest salary in SQL(as/4000

Question Posted / amedela chandra sekhar

29 Answers
32977 Views
iGate, I also Faced
E-Mail Answers

Answer Posted / amedela chandra sekhar

SQL> select * from emp where sal=(select max(sal) from emp
2 where sal<(select max(sal)from emp));

EMPNO ENAME JOB MGR HIREDATE
SAL COMM
---------- ---------- --------- ---------- ---------
---------- ----------
DEPTNO
----------
7788 SCOTT ANALYST 7566 19-APR-87 3000
20

7902 FORD ANALYST 7566 03-DEC-81 3000
20

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can there be 2 primary keys in a table?

1043

How do you use join?

995

What is nosql example?

1096

What are the set operators in sql?

1136

What is a nested table in word?

1009

How does rowid help in running a query faster?

1475

Why should I use postgresql?

1068

Why join is faster than subquery?

1160

Why are aggregate functions called so?

1012

Does inner join return duplicate rows?

1039

What is oracle sql called?

974

Why partition by is used in sql?

1083

Can we use insert statement in function?

1047

How many types of literals are available in pl sql?

1166

how to dump a table to a file with 'mysqldump'? : Sql dba

1100