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
- 7581 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
What is the use of RDBMS?
What is replication with database mirroring? : sql server database administration
How to install sql server 2005 express edition?
Why union all is faster than union?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What is difference between sql and sql server?
Why use identity in sql server?
Can primary key be null?
Explain the commands in sql server?
What is difference between temp table and cte?
Explain error handling in ssis?
Why are sql functions used?
How to encrypt data between dialogs?
What is a heap?
Define master database?
