Question

sql取出不重复的数据,并按ID 排序

SELECT DISTINCT bu_men1, bu_men2, bu_men3, bu_men4
FROM bu_men
where order by id
上面的语句加上where order by id就出错

Answer 1

只要group by一下就行了，
先找出没有重复的，就是吧所有的字段给group ，取出id，
然后去查这些原来表存在的id就行，
SELECT * FORM bu_men where id IN (SELECT MIN(id) FROM bu_men group by bu_men1, bu_men2,bu_men3,bu_men4) order by id
直接拿去跑吧

Answer 2

select * from table a where a.id = (select min(id) from table where 重复的字段=a.重复的字段)
order by id

Answer 3

where去掉,where后面是接条件的

Answer 4

把where去掉就好了，where后面要跟查询的条件，你既然无需条件过滤查询的结果又何必加上where呢