WHERE (1 = 1) AND (NOT EXISTS
(SELECT 1 FROM user WHERE (usid= t.usid) AND (tsid= t.tsid) AND (moreny> t.moreny)))
以上情况如出现 moreny 有等于的 情况 可采取以下方法
SELECT * FROM user AS t
WHERE (1 = 1) and id in (select max(id) from user group by moreny) AND (NOT EXISTS
(SELECT 1 FROM user WHERE (usid= t.usid) AND (tsid= t.tsid) AND (moreny> t.moreny)))
发表评论