fatch specified no

[MHASSANF]

hi how can i fatch specified no of rows starting from some row no. for eg. if i want to fatch records from 5th row to 10th row how can i do it. With Thanks MHF

[Krish KP]

include an autoincrement column. using which this can be done.

Regards KP

[MHASSANF]

i want to know this is only way ? is there any sql syntax ( like TOP ) that return specified no of rows ? MHF

[N a v a n e e t h]

SQL Server 2005 having ROW_NUMBER() function.

---

My Website | Ask smart questions

[Krish KP]

in SQL Server 2000 is not possible., you may try as navaneeth suggesting.

Regards KP