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
5702 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

How can you log an error to the server event log from a stored procedure?

0 Answers

What is normalization? Explain different levels of normalization?

8 Answers CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

What are the three basic rules which are to be followed for the relational model of the database?

0 Answers

How is data stored in dbms?

0 Answers

what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me

1 Answers IBM,

Can an extended stored procedure be called from inside a user-defined function?

0 Answers

Explain about post-relational databases?

0 Answers

What is DB Development software?

0 Answers

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

0 Answers

What are the three types of database design?

0 Answers

What is the system function to get the current user's user id?

4 Answers

What is dbms and its application?

0 Answers

For more DB Development Interview Questions Click Here