Code select*, (selectcount(0) from[picture]where album_id=[album].id) as piccount From[Album]Where id in (5,6,8,1,3,4) orderbycharindex(','+ltrim(rtrim(str(id))) +',',',5,6,8,1,3,4,')
2、查询不重复结果,按照另外一个字段进行排序
Code selectdistinct A,B,max(C) FromTable GroupBy A, B OrderByMax(c)