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
- 6725 Views
- I also Faced
- E-Mail Answers
Answer Posted / chintan
First of all this query doesn't execute. I tried it on SQL
2005 and kept getting error.
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
What are the benefits and tasks of object explorer? : sql server management studio
What is coalesce and check constraint in sql server?
What is function of CUBE ?
What is the difference between SQL notification and SQL invalidation?
How many types of schemas are there?
Explain how to integrate the ssrs reports in application?
What is a trigger and types of a trigger?
What do you mean by SQL injection attack?
What is meant by indexing?
What happens when the SQL Azure database reaches Max Size?
Explain the categories of stored procedure?
Which data type columns are the best candidates for full-text indexing?
Describe in brief system database.
Explain activity monitors
What is ddl command?
