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
- 7580 Views
- I also Faced
- E-Mail Answers
Answer Posted / haris
yah this query works fine and return the 2nd highest salary.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sqlservr.exe - process - sql server (sqlex?press)?
When columns are added to existing tables, what do they initially contain?
What is sqlcmd?
what is the difference between delete table and truncate table commands? : Sql server database administration
Which are ddl commands?
What do you understand by check constraint in sql server?
What are the different types of backups that exist?
What are the benefits of normalization?
Differentiate between delete and truncate.
Different types of keys in SQL?
How to access the inserted record of an event?
Can we join two tables without primary key?
How to get all stored procedures in sql server?
Can We Use Data-grids For Our Report In Ssrs?
How to bind a view to the schema of the underlying tables?
