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 different types of database indexes?

1091

Can a trigger be created on a view?

950

List all the types of user-defined functions?

1092

What is difference between cte and view?

907

How to write a query with a right outer join in ms sql server?

911

How do you know if sql server is running on your local system?

1036

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

962

Tell me what is use of except clause? How it differs from not in clause?

958

What is the use of stored procedure?

933

what is a self join? Explain it with an example? : Sql server database administration

945

What is the security principal at the server level that represents your session?

1009

What happens if you add a new index to large table?

931

Explain data warehousing in sql server?

1039

How can you check the level of fragmentation on a table?

1040

How does using a separate hard drive for several database objects improves performance right away?

926