Is anyone familiar with how exactly to use the TOP command in MSSQL? Is it in it's own SQL query or built into the select query? I'm looking at the help and it doesn't seem very helpful...
Dean ----- Original Message ----- From: "Jason Wong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 16, 2002 2:28 AM Subject: Re: [PHP] Is there an MSSQL limit function? > 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 > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
