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

how to convert numeric values to character strings? : Sql dba

1105

Why is stored procedure faster than query?

960

Which join is like an inner join?

1026

What is record in pl sql?

1083

What is sql query optimization?

1114

what is subquery? : Sql dba

1132

What is meaning of <> in sql?

1067

What is left join example?

947

What is difference between table and view?

1054

Is primary key clustered index?

949

What is the starting oracle error number? What is meant by forward declaration in functions?

994

how to fetch common records from two tables? : Sql dba

1172

What is the purpose of primary key?

1026

How do I get sql certification?

971

What are secondary keys?

971