[AccessD] select top and limit...

[Kostas Konstantinidis]

I'll try this
http://stackoverflow.com/questions/8428641/views-select-contains-a-subquery-
in-the-from-clause

take a look

I also made a question on stackover
/kostas

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

Google...Google...

Looks like you can do this...

Select * from
(Select OrderedList.MyValue from OrderedList Limit 10) TopL Inner join
(Select OrderedList.MyValue, [ and any other fields you want to see] from
OrderedList) AllData On TopL.MyValue = AllData.MyValue;

See http://stackoverflow.com/questions/13400726/mysql-combine-two-queries

Lambert

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

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

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