"from Message as m where m.messageId in (select max(n.messageId) from Message as n group by n.messageTitle)"
先是以重復項分組,分組后用max()函數取出每组的最大的id,这样就得到了每种唯一的一条记录。
出自http://praguesky.blog.163.com/blog/static/23297004200701945151449/