[AccessD] select top and limit...

Kostas Konstantinidis kost36 at otenet.gr
Thu May 5 11:40:44 CDT 2016


It doesn't 

/kostas

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

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

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