mysql - 在mysql的select查询中编写last()函数

Question

SELECT hr.*,hr_leave.*,(SELECT LAST(hr_leave.fromdate) AS lastdate from hr_leave)
FROM hr
INNER JOIN hr_leave
ON hr.id=hr_leave.hrid
WHERE hr.oid=4 AND  hr.ouid=1
ORDER BY
hr_leave.hrid,hr_leave.fromdate
GROUP BY hr_leave.from

谁能告诉我此查询中的错误吗？我不断得到:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(hr_leave.fromdate) AS lastdate from hr_leave) FROM hr INNER JOIN hr_lea' at line 1

Answer 1

现在mysql中已经没有像last这样的东西了，不， http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html

因此要获得所需的结果，请使用查询。 SELECT 列名 FROM 表名 ORDER BY 列名 DESC LIMIT 1