Stuart McLachlan
stuart.mclachlan at gmail.com
Fri Mar 21 15:21:06 CDT 2014
Top and Limit are not the same as Fisrt. Those two restrict the number of recordsreturned, regardless of the content of any particular field. An alternative in earleir versions of T-SQL would be to use Min or Max to achieve the same result. But now TSQL 2012 has First_Value.... OVER (PARTITION BY...) (same as MySQL). On 21 Mar 2014 at 10:16, Arthur Fuller wrote: > Charlotte (et. al.), > > Slight change to what you wrote: FIRST is not a grouping option in > SQL; it's Access-specific. IN MS-SQL it's TOP [n[/%]]. In MySQL and > MariaDB it's LIMIT [n]. > > Arthur > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >