limiting amount of returned rows?

27/03/2006, 15h40

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

27/03/2006, 18h48

"Sonnich" <sonnich.jensen@elektrobit.com> wrote in message
news:1143474015.916066.15640@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.

27/03/2006, 19h12

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;

28/03/2006, 12h28

Bill Karwin wrote:
> "Sonnich" <sonnich.jensen@elektrobit.com> wrote in message
> news:1143474015.916066.15640@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

27/03/2006, 15h40	#1
Sonnich Messages: n/a Hébergeur:	limiting amount of returned rows? 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

27/03/2006, 18h48	#2
Bill Karwin Messages: n/a Hébergeur:	Re: limiting amount of returned rows? "Sonnich" <sonnich.jensen@elektrobit.com> wrote in message news:1143474015.916066.15640@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.

27/03/2006, 19h12	#3
noone Messages: n/a Hébergeur:	Re: limiting amount of returned rows? 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;

28/03/2006, 12h28	#4
Sonnich Messages: n/a Hébergeur:	Re: limiting amount of returned rows? Bill Karwin wrote: > "Sonnich" <sonnich.jensen@elektrobit.com> wrote in message > news:1143474015.916066.15640@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

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email