Have a look at GROUP BY and aggregate functions:
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html
- Original Message -
> From: "Norman Khine"
> To: mysql@lists.mysql.com
> Sent: Thursday, 23 June, 2011 4:05:35 PM
> Subject: sql query advise
>
> hello,
> i have this SQL cod
hi martin,
On Fri, Apr 23, 2010 at 9:50 PM, Martin Gainty wrote:
> Norm-
> I would strongly suggest locking the table before updating..a SELECT for
> UPDATE would accomplish that objective:
thanks for the reply and the advise on locking the table
>
> """SELECT oppc_id, limitedDate FROM db1.partn