Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

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 post-relational databases?

0 Answers  


How to read and create .LDC data files which are used by linguatic dictionary.

0 Answers  


Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

0 Answers   IBM,


How to generate OIDS

0 Answers  


Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,






In which database can extended stored procedures be added?

0 Answers  


what is the use of foreginkey

2 Answers  


Write short notes on manual refreshes.

0 Answers  


Write the difference between case version and decode version.

2 Answers  


Explain about relational operator join?

0 Answers  


explain detail about ftp in datastage?

0 Answers   IBM,


What are triggers? How many triggers you can have on a table?

2 Answers   Ramco,






Categories