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

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to