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
- 7592 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 is primary key index?
what is a self join? Explain it with an example? : Sql server database administration
Distinguish between nested subquery and correlated subquery?
What is the sql case statement used for? Explain with an example?
What are the system database in sql server 2005?
What is use of except clause?
How to create a scrollable cursor with the scroll option?
Is a primary key unique?
How can you start sql server in different modes?
How to create a user to access a database in ms sql server using "create user" statements?
What are the different Topologies in which Replication can be configured?
what is normalization? : Sql server database administration
What are the two modes of authentication in sql server?
What are the advantages of paper records?
What are truncate options available in sql server? : sql server database administration
