SELECT * FROM MailMessage A
WHERE id in
(SELECT TOP 1 id FROM MailMessage
WHERE A.Mfromid = Mfromid ORDER BY MsendTime DESC
) and Mtoid=3
列出每个用户的最新文章
最新推荐文章于 2023-07-17 19:54:22 发布
SELECT * FROM MailMessage A
WHERE id in
(SELECT TOP 1 id FROM MailMessage
WHERE A.Mfromid = Mfromid ORDER BY MsendTime DESC
) and Mtoid=3