Doing a Top 'x' with a MySQL Db

[Laphan]

Although I know I can do a Top 'x' (x being the number I want) in Access and
SQL Server, I've been told that this isn't possible in MySQL. Is this true?

My ASP would only query a loop of say 5 recs anyway, but bringing the whole
lot back to do this seems messy.

Any ASP get-arounds if this is the case?

Thanks

Laphan

[Manohar Kamath [MVP]]

[url]http://dev.mysql.com/doc/mysql/en/SELECT.html[/url]

mySQL offers the LIMIT clause instead of the TOP clause. So, to retrieve top
5 rows, do:

SELECT * FROM myTable LIMIT 5;

--
Manohar Kamath
Editor, .netWire
[url]www.dotnetwire.com[/url]


"Laphan" <news@DoNotEmailMe.co.uk> wrote in message
news:40c22e29_3@127.0.0.1...

> Although I know I can do a Top 'x' (x being the number I want) in Access

and

> SQL Server, I've been told that this isn't possible in MySQL. Is this

true?

>
> My ASP would only query a loop of say 5 recs anyway, but bringing the

whole

> lot back to do this seems messy.
>
> Any ASP get-arounds if this is the case?
>
> Thanks
>
> Laphan
>
>

[Laphan]

many thanks Manohar


Manohar Kamath [MVP] <mkamath@TAKETHISOUTkamath.com> wrote in message
news:O9ipcL#SEHA.3768@TK2MSFTNGP11.phx.gbl...
[url]http://dev.mysql.com/doc/mysql/en/SELECT.html[/url]

mySQL offers the LIMIT clause instead of the TOP clause. So, to retrieve top
5 rows, do:

SELECT * FROM myTable LIMIT 5;

--
Manohar Kamath
Editor, .netWire
[url]www.dotnetwire.com[/url]


"Laphan" <news@DoNotEmailMe.co.uk> wrote in message
news:40c22e29_3@127.0.0.1...

> Although I know I can do a Top 'x' (x being the number I want) in Access

and

> SQL Server, I've been told that this isn't possible in MySQL. Is this

true?

>
> My ASP would only query a loop of say 5 recs anyway, but bringing the

whole

> lot back to do this seems messy.
>
> Any ASP get-arounds if this is the case?
>
> Thanks
>
> Laphan
>
>