Thread: LIMIT

LIMIT

From
"Mr. Poet"
Date:
Could someone give me an example of a select * with LIMIT used 
by 6.5? --poet@linuxports.com--     ICQ: 33017215http://www.linuxports.com --Power to the Penguin--


Re: [SQL] LIMIT

From
Chris Bitmead
Date:
"Mr. Poet" wrote:
> 
> Could someone give me an example of a select * with LIMIT 
> used by 6.5?

SELECT * FROM foobar LIMIT 100


Re: [SQL] LIMIT

From
Dirk Lutzebaeck
Date:
Besides, I have problems with SELECT LIMIT on unions in
6.5beta1. Anyone else?

Dirk


Re: [SQL] LIMIT

From
Mark Jewiss
Date:
> > Could someone give me an example of a select * with LIMIT 
> > used by 6.5?
> 
> SELECT * FROM foobar LIMIT 100

Or you could use ROWCOUNT...

set rowcount = 10
select * from table

Regards,

Mark.
--
Mark Jewiss
Knowledge Matters Limited



Re: [SQL] LIMIT

From
José Soares
Date:

Dirk Lutzebaeck ha scritto:

> Besides, I have problems with SELECT LIMIT on unions in
> 6.5beta1. Anyone else?
>
> Dirk

LIMIT doesn't work with UNION, I think this is a known bug.

José