1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Following are some of the question related to below
mentioned query?

select e1.salary from employee3 e1
where 2=
(
select count(distinct(e2.salary))
from employee3 e2 where e2.salary>=e1.salary
)

1) What the query returns?

2) How it works? - Detail explanation (what the sub query
does, why it is (where 2=)....etc...Please?

Question Posted / ashok

Answers were Sorted based on User's Feedback



Following are some of the question related to below mentioned query? select e1.salary from empl..

Answer / ashok

Hi

1.Here query will return 2nd highest salary
2.here 2= i.e 2nd heigest similary if we set N in place
of 2 then it will returen Nth heigest salary
where n =1,2,3,4.....

Hope it will help u

Ashok

Is This Answer Correct ?    4 Yes 0 No

Following are some of the question related to below mentioned query? select e1.salary from empl..

Answer / ashok

Hi

1.Here query will return 2nd highest salary
2.here 2= i.e 2nd heigest similary if we set N in place
of 2 then it will returen Nth heigest salary
where n =1,2,3,4.....

Hope it will help u

Ashok

Is This Answer Correct ?    3 Yes 0 No

Following are some of the question related to below mentioned query? select e1.salary from empl..

Answer / suraj

This query does execute, you stupid.
Have some self respect. Do not post comments unless you are
very sure about it.

Is This Answer Correct ?    1 Yes 0 No

Following are some of the question related to below mentioned query? select e1.salary from empl..

Answer / haris

yah this query works fine and return the 2nd highest salary.

Is This Answer Correct ?    0 Yes 0 No

Following are some of the question related to below mentioned query? select e1.salary from empl..

Answer / chintan

First of all this query doesn't execute. I tried it on SQL
2005 and kept getting error.

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More SQL Server Interview Questions

difference between truncate, delete aur drop?

2 Answers  

What is the contrast amongst drop and truncate?

0 Answers  

Define inner join? Explain with an example?

0 Answers  

What is a Linked Server?

1 Answers  

how to create a scrollable cursor with the scroll option? : Sql server database administration

0 Answers  




Define tool Manage Statistics in SQL Server 2000 query ?

0 Answers   NA,

what is Archive old data?

1 Answers  

What is instead of dml trigger?

0 Answers  

Explain “@@rowcount” and “@@error” in sql server?

0 Answers  

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

0 Answers  

What is postgresql server?

0 Answers  

How to create hyperlink from returned sql query ?

0 Answers   MCN Solutions,

For more SQL Server Interview Questions Click Here
Categories