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
- 7817 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
Explain different types of locks in sql server.
What is subreport?
What is the maximum size of a row in sql server?
Working with TLogs
How to include date and time values in sql statements?
How do I save a stored procedure in sql server?
List out different types of normalizations in sql server and explain each of them?
What's the information that can be stored inside a bit column?
Explain full-text query in sql server?
What is a collation in ms sql server?
What are statistics?
Can sql servers linked to other servers?
What is transaction server isolation?
In what three ways is the return statement used in a stored procedure?
What is the data type of time?
