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
- 8046 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ashok
Hi
1.Here query will return 2nd highest salary
2.here 2= i.e 2nd heigest similary if we set N in place
of 2 then it will returen Nth heigest salary
where n =1,2,3,4.....
Hope it will help u
Ashok
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ashok
Hi
1.Here query will return 2nd highest salary
2.here 2= i.e 2nd heigest similary if we set N in place
of 2 then it will returen Nth heigest salary
where n =1,2,3,4.....
Hope it will help u
Ashok
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / haris
yah this query works fine and return the 2nd highest salary.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What are the different ways of moving data/databases between servers and databases in SQL Server?
what are the advanced features in sql 2008?
Define left outer join?
Where the sql logs gets stored? : sql server database administration
Which command using Query Analyzer will give you the version of SQL server and operating system?
Explain what are the restrictions while creating batches in sql server?
What is the need for group functions in sql?
Do you know what are acid properties of transaction?
How to write stored procedure to update the data in 10 tables
What do you understand by a view? What does the with check option clause for a view do?
Explain partitioned view?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
