how to find the first two highest salaries in deptno in emp table

how to find the first two highest salaries in deptno in emp
table

Question Posted / guest

2 Answers
5486 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to find the first two highest salaries in deptno in emp table..

Answer / santhosh kandula

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 )

Is This Answer Correct ?

6 Yes

1 No

how to find the first two highest salaries in deptno in emp table..

Answer / ajitnayak

select e.*
from emp e
where rownum < 3
order by e.sal desc ;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More DB Development Interview Questions

Explain about relational operator join?

0 Answers

Explain about the relational database?

0 Answers

can you give me the syntax of named procedure??

2 Answers

How to use online Backups?

0 Answers

In which database can extended stored procedures be added?

0 Answers

How to combine two function together?

0 Answers

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

0 Answers

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

0 Answers Covansys,

Explain about a primary key?

0 Answers

In which table collections errors are stored.

0 Answers

Explain the family trees and connection by clause.

1 Answers

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

0 Answers

For more DB Development Interview Questions Click Here