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

How can change procedure in sql server?

1051

What is extended stored procedures?

952

What is the sql server 2000 version number?

1072

When columns are added to existing tables, what do they initially contain?

1023

What is a data collection table?

1000

Describe different Processing Modes offered by SSRS?

248

What is a field name?

955

What is multilevel indexing?

922

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1014

What are different types of roles provided by ssrs?

150

How to execute stored procedure and set temp table in sql server?

1030

How to get a list of all tables with "sys.tables" view in ms sql server?

1028

Explain index in sql server?

1006

How would you add a section to a table?

1024

Can you explain full-text query in sql server?

1001