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
- 7765 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 provisioning, billing and metering, and connection routing concepts in the service layer?
What is user-defined function?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How to defragment table indexes?
What is the command dbcc checkdb used for?
What is temporal table?
What is delete query?
How do I find my localdb version?
What are number line correlation administrators will use while working with a subquery?
How to delete duplicate rows?
Describe the functionalities that views support.
What is sql server schema compare? How we can compare two database schemas?
Explain sql server service broker?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What are database states in ms sql server?
