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