Is there an MSSQL limit function?
| From: | Dean Householder | Date: | Sat, 16 Feb 2002 09:14:47 +0000 |
| Subject: | Is there an MSSQL limit function? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-85009@lists.php.net to get a copy of this message | ||
I want to run a query like:
select * from table order by rand() limit 3
in MySQL it would work but I need to run it in MSSQL. I've been searching for a limit function
in MSSQL and I can't find a way to do it. I'm experienced with MySQL but know nothing
about MSSQL. If someone could point me in the right direction I would really appreciate it!
Thanks,
Dean