DB Development Interview Question:

How to find the first two highest salaries in deptno in emp table?

Submitted by: Administrator

if u want select the second highest salary from the emp
table then u have to write query as

select max(salary) from emp where
salary < ( select max(salary) from emp )
Submitted by: Administrator