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
What is the server name in sql server?
Define synonym?
How to list all user defined functions in the current database?
What are the dmvs? : sql server database administration
How can I check if a view exists in a sql server database?
What is normalization? Explain its different types?
What do you mean by SQL injection attack?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What is dknf in normalization form?
What is always encrypted?
What is the maximum rows in sql server table?
Determine when an index is appropriate?
Difference between DELETE and TRUNCATE?
Can we join two tables without primary key?
Why use sub query in sql server and list out types of sub queries?