Re: Is there an MSSQL limit function?
| From: | Jason Wong | Date: | Sat, 16 Feb 2002 09:28:03 +0000 |
| Subject: | Re: Is there an MSSQL limit function? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-85010@lists.php.net to get a copy of this message | ||
On Saturday 16 February 2002 17:14, Dean Householder wrote:
> 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!
I think it's TOP in MSSQL.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
Let's remind ourselves that last year's fresh idea is today's cliche.
-- Austen Briggs
*/