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?
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
Find columns used in stored procedure?
Explain use of expression builder.
What is a DBMS, query, SQL?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
Explain the commands in sql server?
How many types of schemas are there?
What is #table in sql server?
Mention the differences between local and global temporary tables.
How to delete duplicate records based on single column from a table?
Explain the rules for designing files and file groups in sql server?
What is difference between rollback immediate and with no_wait during alter database?
Can you explain what is indexed view? How to create it?
How can we solve concurrency problems?
How many replicas are maintained for each SQL Azure database?
What are the different types of triggers in SQL SERVER?