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
32240 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

What are the packages in pl sql?

1013

What is varchar sql?

1150

what is query cache in mysql? : Sql dba

1040

Define commit, rollback and savepoint?

1033

How sql query is executed?

1136

How does sql developer connect to oracle database?

1006

what are local and global variables and their differences? : Sql dba

1073

How do you delete a table?

1082

What found sql?

947

what is blob? : Sql dba

1154

What is a trigger in sql?

1207

What is dynamic sql in pl sql?

1038

What are literals in sql server?

1174

how to select unique records from a table? : Sql dba

1115

what is the command used to fetch first 5 characters of the string? : Sql dba

1640