在SQL中。如果使用SELECT DISTINCT(A) FROM TABLE ORDER BY 。。。时,后面ORDER BY 后的字段名必须在前面选择时出现,比如 select distinct(D1) from shop order by D1 这样才不会出现冲突,如果是select distinct(D1) from shop order by D2 则会发生冲突;
还有就是如果ORDER BY 字段的长度也要用上面的规则。如依据D1的长度来排序,如果写成select distinct(D1) from shop order by len(D1) 那还是会出错,必须写成select distinct(D1),len(D1) from shop order by len(D1) 才可以。
Select classname1 From classname group by classname1 order by min(ID)