工作中遇到这样的需求,需要查询出各种type的最新一条记录
结合网上搜索的参考(链接:http://blog.sina.com.cn/s/blog_6a0cd5e5010139ot.html)
自己实际写出的sql如下:
SELECT
type,
senderName,
subTitle
FROM
(
SELECT DISTINCT
TYPE AS type,
SENDER_USERNAME AS senderName,
TARGET_NAME AS subTitle
FROM
`feed_message`
WHERE
RECEIVER = #{userId}
AND `READ` = #{read}
AND TENANT_KEY = #{tenantKey}
ORDER BY
CREATE_TIME DESC
) f
GROUP BY
type