how to find nth highest salary
Answer Posted / ravikiran
select * from employee.e1 where (n-1) =
( select (distinct b.salary ) from employee.e2 where e1.salary > e2.salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What type of locking occurs during the snapshot generation? : sql server replication
Why are sql functions used?
What is a subquery in a select query statement in ms sql server?
Explain the different types of backups available in sql server? : sql server database administration
Can an entity have two primary keys?
What is store procedure? How do they work? When do you use?
What are the functions in sql server?
What are the pre-defined functions in the sql server?
Does group by sort data?
What is cursors?
How to create dbo table in sql server?
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
write an SQL query to list the employees who joined in the month of January?
Explain transaction server consistency?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?