MAX and SUM Aggregate Functions
(About.com) In a recent forum message, SQLHunter wrote:
'I am trying to get the pub_id and maximum total revenue from a titles table which lists pub_id, sales, price. I can get either a listing with pub_id and total revenues for each pub_id with
SELECT PUB_ID,
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1129 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1129]
updated 1129 (Databases), inserted 9, updated 0, at 2012-05-27 17:23:02
