Thread: LIMIT

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--

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

SELECT * FROM foobar LIMIT 100

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

Dirk

> > 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

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é