RE: [PHP] Nothing to do with PHP
| From: | (Edward Peloke) | Date: | Mon, 30 Jun 2003 19:36:22 +0000 |
| Subject: | RE: [PHP] Nothing to do with PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-153465@lists.php.net to get a copy of this message | ||
I believe you would achieve the same results by saying select top 10 * from
system_users where lastnamelike "C%"
Eddie
-----Original Message-----
From: Cesar Cordovez [mailto:phpguru@cesamo.com]
Sent: Monday, June 30, 2003 3:21 PM
To: php-general@lists.php.net
Subject: [PHP] Nothing to do with PHP
But, I'm sure someone in this list have the answer to my question: I
have written a lot of statements using the LIMIT clause in MySQL, like
for example: SELECT * FROM system_users WHERE lastname like "C%" LIMIT
0,10 ...and I love it. specially when you are doing "next page",
"previous page" kind of stuff. One of my clients wants to install my
system in (*&^%$# MSSQL server. How can I do a LIMIT in MSSQL (or other?)
Any comments welcome.
TIA.
Cesar
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php