How to select nth record from a table?
Answer Posted / saravanan p
select * from
(select row_number() over(order by empid) rno,* from tbl)
tbl1
where tbl1.rno=n
| Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
Define Joins?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
What are rows and columns?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What are three major types of constraints?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is a functions and types in sql server?
explain different types of joins? : Sql server database administration
What is command parameter in ssrs?
What is exporting utility?
What is sql injection? How to protect against sql injection attack?
What is the most common trace flags used with sql server?
Which joins are sql server default?
How can you check the level of fragmentation on a table?
How many tables can be joined in SQL Server?