有个需求,需要取出一个表中 所有用户的最新记录,根据这个记录进行一些统计计算,
如果时单表查询 语句:
SELECT * FROM (
SELECT userid,MAX(createtime) AS createtime FROM table
GROUP BY userid ) a
WHERE where
如果需要和其他表关联查询的:
SELECT tableA.*,tableB.price FROM (
SELECT * FROM (
SELECT userid,MAX(createtime) AS createtime FROM table
GROUP BY userid ) a
WHERE where
) tableA
LEFT JOIN table tableB
ON tableA.field = tableB.field