1.distinct是针对多字段完全一样的去重
2.多个字段针对其中一个字段去重:
select * from BB_CREDIT_RESULT where rowid in (select max(rowid) from BB_CREDIT_RESULT group by COURSE_ID)
2.多个字段针对其中一个字段去重:
select * from BB_CREDIT_RESULT where rowid in (select max(rowid) from BB_CREDIT_RESULT group by COURSE_ID)