[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