摘要:
FIND_IN_SET的使用,前面介绍过,distinct是结果去重复的函数,两者结合使用,却花费了我一天的光阴。1、先面试含有重复值正确的显示顺序select lIdfrom tbCourse1 as a left join tbCourseClassify as b on a.lId=b.lCourseId where (a.nUserType=1 or a.nUserType=0) and a.strServiceids like '%.0.%' and b.nType in (-1,10,9,11,12,18,19,32,1,2,3,4,5,6,7,8,52,53,54 阅读全文