Interested to Buy Any Domain ? << Click Here >> for more details...
Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
- 8 Answers
- 12951 Views
- I also Faced
- E-Mail Answers
Answer Posted / v rajkumar
select salary from Emp a where 4 = (select count(distinct
(salary)) from Emp b where b.salary>= a.salary)
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is a Join and explain its types?
Why do we backup Active Directory ?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Can you insert NULL in unique column?
How to select true false based on column value in sql server?
Explain what are the authentication modes in sql server?
How you can find out if an index is useful to the optimizer?
Difference between DELETE and TRUNCATE?
Explain “row_number()” in sql server with an example?
What is the Control Flow in SSIS
What is a ddl statement?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is nolock?
What are the different types of join?
Explain atomicity?
