How to find 6th highest salary from Employee table ?
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
What are the difficulties faced in cube development? : sql server analysis services, ssas
Is truncate a dml command?
What happens to a trigger with multiple affected rows?
How to override dml statements with triggers?
What is user defined stored procedures?
How to recover from sql injection? : sql server security
What is the difference between drop table and truncate table?
Explain microsoft sql server functions?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What is a covered index?
Explain transaction server implicit?
What is a linked server in sql server?
When does a workload on SQL Azure get throttled?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
How to modify existing triggers using "alter trigger"?