sql 中distinct()的用法: http://www.cnblogs.com/rainman/archive/2013/05/03/3058451.htmlhttps://blog.csdn.net/boss2967/article/details/79019467 sql中group by的用法: