how to find nth highest salary
Answer Posted / kavitha. r
select top 1 salary from employee where salary in (select
top n salary from employee order by salary desc) order by
salary desc
| Is This Answer Correct ? | 12 Yes | 40 No |
Post New Answer View All Answers
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
How to delete duplicate rows from table except one?
What are the differences between lost updates and uncommitted dependencies?
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 database you used in your final year project?
What are the advantages to use stored procedures?
How to insert stored procedure result into temporary table?
on line cluster can we make if yes tell me the procedure
What are data regions?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
Why are you getting errors when creating a new odbc dsn?
Why do you need a sql server?
Does sql server 2016 have ssms?
What do you mean by an execution plan? How would you view it?
What is the language structure to add a record to a table?