limiting amount of returned rows?

[Sonnich]

Hi!

How do I limit the amount of returned rows?

Lets say, that I want only the latest 400 rows (of e.g. 4034634 rows) -
is there a parameter for that like rownum in Oracle?

e.g. select * from someplace where rownum < 400 order by sometimefield?

BR
Sonnich

[Bill Karwin]

"Sonnich" <so************@elektrobit.com> wrote in message
news:11*********************@z34g2000cwc.googlegro ups.com...

How do I limit the amount of returned rows?

The optional LIMIT clause of queries can do this.

Read about it on this page:
http://dev.mysql.com/doc/refman/5.0/en/select.html

Starting at the bullet item that begins, " The LIMIT clause can be used to
constrain the number of rows returned..."

Regards,
Bill K.

[noone]

Sonnich wrote:

Hi! How do I limit the amount of returned rows? Lets say, that I want only the latest 400 rows (of e.g. 4034634 rows) -
is there a parameter for that like rownum in Oracle? e.g. select * from someplace where rownum < 400 order by sometimefield? BR
Sonnich

http://dev.mysql.com/doc/refman/4.1/...imization.html

select * from someplace where order by sometimefield limit 400;

[Sonnich]

Bill Karwin wrote:

"Sonnich" <so************@elektrobit.com> wrote in message
news:11*********************@z34g2000cwc.googlegro ups.com...

How do I limit the amount of returned rows?

The optional LIMIT clause of queries can do this.

Read about it on this page:
http://dev.mysql.com/doc/refman/5.0/en/select.html

Starting at the bullet item that begins, " The LIMIT clause can be used to
constrain the number of rows returned..."

Thanks, that works well.

Sonnich