But with TOP  I can't start on any row I want? I would like to be able to 
select rows 40 through 60 or something similar.

/F

>>>>>>>>>>>>>>>>>> Ursprungligt meddelande <<<<<<<<<<<<<<<<<<

Trey Sheldon <[EMAIL PROTECTED]> skrev 2001-03-12, kl. 15:35:38 angående 
ämnet Re: [PHP-DB] LIMIT in MS SQL:


> Yep there is- its called TOP

> Example:

> SELECT TOP 2 *
> FROM Table


> Fredrik Wahlberg wrote:

> > Is there any equivalent to MySQL's ?LIMIT x,y? in Microsoft SQL-Server?
> >
> > /Fredrik
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]


> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to