[AccessD] select top and limit...

Stuart McLachlan stuart at lexacorp.com.pg
Thu May 5 16:18:21 CDT 2016


Yep, that should work as well :)

On 5 May 2016 at 13:54, Heenan, Lambert wrote:

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




More information about the AccessD mailing list