Nothing to do with PHP
| From: | Cesar Cordovez | Date: | Mon, 30 Jun 2003 19:20:46 +0000 |
| Subject: | Nothing to do with PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-153463@lists.php.net to get a copy of this message | ||
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