Re: LIMIT in MS SQL
| From: | Fredrik Wahlberg | Date: | Mon, 12 Mar 2001 15:00:00 +0000 |
| Subject: | Re: LIMIT in MS SQL | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-7329@lists.php.net to get a copy of this message | ||
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 <gsheldon@vt.edu> 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: php-db-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-db-help@lists.php.net
> > To contact the list administrators, e-mail: php-list-admin@lists.php..net
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net