SQL instruction

<i><b>Originally posted by : pit (pierre.paradoms@co.Arianeii.be)</b></i><br />Somebody can help me? i want to create a query in sql to have results between two position<br />example : i have a query which returns 1000 records but i want to have just only the records between the row 10 and the row 20<br /><br />thank you in advance

<i><b>Originally posted by : notimportant (jhunt@alagreen.com)</b></i><br /><br />Try select top 20 * from mytable then take the result and move past the first 10 rows.<br /><br />------------<br />pit at 3/29/2001 8:29:27 AM<br /><br />Somebody can help me? i want to create a query in sql to have results between two position<br />example : i have a query which returns 1000 records but i want to have just only the records between the row 10 and the row 20<br /><br />thank you in advance