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
- 8042 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
How can you know if the row fetched from cursor is still valid in underlying table?
What is query cost in sql server?
when you create a database how is it stored? : Sql server database administration
What are information schema views?
Can you name a few encryption mechanisms in sql server?
What is the use of keyword with encryption.
Why Master database is required?
What language is sql server written in?
How fixed length strings are truncated and padded?
what's sql server? : Sql server database administration
Explain in details security in SQL azure?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
Explain primary key and foreign key constraints?
What is filestream?
What is the fastest way to permanently delete a 1 million row table named customers?
