DB Development Question:
Download Questions PDF

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

Answer:

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 )

Download DB Development Interview Questions And Answers PDF

Previous QuestionNext Question
Explain the syntax of named procedure?What is difference between primary key and unique key?