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
Mention the uses of stored procedures.
How would you add a section to a table?
How to rename databases in ms sql server?
Do you know clustered and non-clustered index?
Explain log shipping and mention its advantages.
Why I can not enter 0.001 second in date and time literals in ms sql server?
How real and float literal values are rounded?
Explain the etl (extraction, transformation, and loading)?
Define indexes?
Does sql server 2016 have ssms?
What is difference between global temporary tables and local temporary tables?
How to create user defined functions with parameters?
What is side by side migration in sql server?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What are the different authentication modes in sql server?