limit command

[teroy]

Hi there,
If i do a sql query that returned 25 rows
say select * from customer

how do i get rows 10 to 20?

I use another dbase called postgreSQL and the way it does it is

select * from customer limit 10,10

wheras the first 10 is how many rows you want returned and the 2nd 10 is where you want it to start

I'm sure sql server has an equivalent but i'm not sure of the syntax

Much help appreciated

 

[tlbroadbent]

There is no equivalent in SQL Server. Terry

http://members.home.net/tlbroadbent/index.htm

 

[teroy]

Thanks anyway

 

[foxdev]

There are several work arounds, including:

* clever use of ORDER BY and TOP (though it may not help in a particular situation)

* using a cursor

* if the rows have a numeric sequential key, select a range based on that. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com