how to select 5 to 7 rows from a table, which contains 10 rows?
Answer Posted / narayana
select * from emp order by empid
offset 4 rows
fetch next 3 rows only
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a ddl statement?
Can you explain various data region available in ssrs with their use?
How to use old values to define new values in update statements in ms sql server?
What is statement level trigger?
What to check if a User database is locked?
How to add an address record into adventureworkslt?
How to convert numeric values to integers in ms sql server?
What does select 1 mean?
Explain different forms of normalization?
Can you please explain the difference between primary keys and foreign keys?
Describe and explain about SQL native client?
What is the difference between substr and charindex in the sql server?
What are the different acid properties?
What is the most common type of join?
What are the parts of a function?