DB Development Question: Download DB Development PDF

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

Tweet Share WhatsApp

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 PDF Read All 10 DB Development Questions
Previous QuestionNext Question
Explain the syntax of named procedure?What is difference between primary key and unique key?