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
- 6712 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 view in sql?
What is collation sensitivity?
Can we insert data into a view?
What are the types of database schema? : sql server analysis services, ssas
What is the new security features added in sql server 2014? : sql server security
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
Which joins are sql server default?
What are commit and rollback in sql?
How to create a trigger for insert only?
Explain transaction server implicit?
How to include date and time values in sql statements?
What is buffer cash in sql server?
What is sql collation?
Differentiate between ms sql server reporting services vs crystal reports?
What are the different authentication modes in sql server? How can it be changed?
