[AccessD] select top and limit...

[Heenan, Lambert]

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