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 are the advantages of paper records?
Can a table be moved to different filegroup?
Explain the difference between HTTP and HTTPS in database?
What the different components of Replication and what is their use?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
Mention the command used to rename the database.
What is page in sql server?
Define outer join?
How to create a dynamic cursor with the dynamic option?
What is bcnf normalization form?
Explain the creation and execution of a user-defined function in the sql server?
How many types of functions are there in sql server?
Explain the first normal form(1nf)?
When to use null data driven subscription?
What is dbcc? Give few examples.