Re: Is there an MSSQL limit function?
| From: | Jason Wong | Date: | Sat, 16 Feb 2002 09:54:04 +0000 |
| Subject: | Re: Is there an MSSQL limit function? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-85013@lists.php.net to get a copy of this message | ||
On Saturday 16 February 2002 17:48, Dean Householder wrote:
> 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...
It's been a while since I last used MS dbs. But I think it goes something
like:
SELECT * FROM table TOP 5;
In fact I checked the help of Access and it is detailed there.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
The primary requisite for any new tax law is for it to exempt enough
voters to win the next election.
*/