select * from emp order by empid offset 4 rows fetch next 3 rows only

how to select 5 to 7 rows from a table, which contains 10 rows?

Question Posted / narayana

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

Please Help Members By Posting Answers For Below Questions

What are the advantages of paper records?

1010

Can a table be moved to different filegroup?

1025

Explain the difference between HTTP and HTTPS in database?

1092

What the different components of Replication and what is their use?

1124

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

945

Mention the command used to rename the database.

1049

What is page in sql server?

995

Define outer join?

1045

How to create a dynamic cursor with the dynamic option?

1103

What is bcnf normalization form?

1158

Explain the creation and execution of a user-defined function in the sql server?

1111

How many types of functions are there in sql server?

984

Explain the first normal form(1nf)?

1076

When to use null data driven subscription?

213

What is dbcc? Give few examples.

1083