Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 8038 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How you trouble shoot when any job fails
What is the tcp/ip port on which sql server runs?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
How can I add Reporting Services reports to my application?
What are types of subqueries?
what's the difference between a primary key and a unique key? : Sql server database administration
What is primary key, unique key, and foreign key?
Explain the steps to create and execute a user-defined function in the sql server?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is snapshot report?
What are rows and columns?
How to check status of stored procedure in sql server?
Explain an incremental backup?
What is filtered index?
What is mscorsvw.exe - process - microsoft .net framework ngen?
