`

取得表某个分组的最大值

 
阅读更多

select * from tablename a where a.createdate=(select max(b.createdate) from tablename b where a.channel=b.channel)

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics