摘要：
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 阅读全文
posted @ 2013-10-12 14:28
风中鸣，雨中行
阅读(631)
评论(0)
推荐(0)