2011-06-01から1ヶ月間の記事一覧
select t.autoId, m.takenDt, m.tag from sales t join (select tag, max(takenDt) as takenDt from sales group by tag) m on t.tag = m.tag and t.takenDt = m.takenDt;MySQL Forums :: General :: select Max(field), field2 returns wrong field2 http:/…