[AccessD] select top and limit...

Heenan, Lambert Lambert.Heenan at aig.com
Thu May 5 10:59:36 CDT 2016


Hmm.

Don't know if MySQL supports the use of "With"  like this (Oracle syntax)...

With OLTop as (
Select OrderedList.MyValue from OrderedList Limit 10
)

Select
OrderedList.MyValue from OrderedList inner join  OLTop on OLtop.MyValue = OrderedList.MyValue

Lambert


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas Konstantinidis
Sent: Thursday, May 05, 2016 11:27 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] select top and limit...

Hi Lambert,

I get

ERROR 1235 : This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

Thank;s
/kostas

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Thursday, May 5, 2016 4:55 PM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] select top and limit...

Kostas,

OTTOMH...

Select OrderedList.MyValue from OrderedList Where OrderedList.MyValue In (Select OrderedList.MyValue from OrderedList Limit 10);

Lambert

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas Konstantinidis
Sent: Thursday, May 05, 2016 3:46 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] select top and limit...

Hi all,
I uae "LIMIT 10" in mysql query but what I really need is get also all the equal values with the 10th record I know that ms access do it by default with "select top" but I can't  make it to work in mysql Could you please help?

Thank's
/kostas

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list