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
31151 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 is normalization? How many normalization forms are there?

1010

Write a unique difference between a function and a stored procedure.

924

What is an example of translating a date into julian format?

1038

How to pronounce postgresql?

1005

What is the difference between joins?

974

What is keys and its types?

1019

what is an index? : Sql dba

929

What is a sql trace file?

977

What is the purpose of the sql select top clause?

1018

What are different clauses used in sql?

1072

difference between anonymous blocks and sub-programs.

1079

What are the indexing methods?

1001

What are different sql data types?

953

Why is theta join required?

1080

Is pl sql a scripting language?

969