Interested to Buy Any Domain ? << Click Here >> for more details...
How to find 6th highest salary from Employee table ?
- 10 Answers
- 23673 Views
- I also Faced
- E-Mail Answers
Answer Posted / lince thomas
select salary from(
select row_number() over(order by salary desc) as rno,*
from Employee)T where T.rno=6
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
If user is owning any SQL Objects, can we drop that user
What are the two modes of authentication in sql server?
Define master database?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What are the differences between user defined functions and stored procedures?
Which is better statement or preparedstatement?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
Can you get second highest salary from the table?
Benefits of Stored Procedures?
What is the difference in accessing db between sql server vs sql azure?
What is save transaction and save point?
What is stored procedures?
Explain something about security and SQL Azure?
What is a mixed extent?
What happens if null values are involved in boolean operations?
