select * from Tablename limit 5,7 ;

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

Question Posted / tk

Answer Posted / tk

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is bcp? When does it use?

943

What are the restrictions that views have to follow?

972

What is equi join with example?

1130

How to create stored procedures with parameters in ms sql server?

1079

What objects does the fn_my_permissions function reports on? : sql server security

1034

How do use Having,Group by,Group function in SQL?

1744

what kind of lan types do you know? : Sql server database administration

980

Do you know what are the differences between lost updates and uncommitted dependencies?

1081

What is user-defined scalar function?

966

List out the different types of locks available in sql server?

978

Explain few of the new features of sql server 2008 management studio

920

How to write an inner join with the where clause in ms sql server?

1091

What is acid mean in sql server?

1119

Explain full-text query in sql server?

1006

How to use old values to define new values in update statements in ms sql server?

1268