select * from app_user t where t.id <3 or t.id > 3110 and t.id = 3110;
select * from app_user t where t.id <3 or (t.id > 3110 and t.id = 3110);
select * from app_user t where t.id <3 and t.id = 1 or t.id > 3110 and t.id = 3110 or t.id = 3000;
select * from app_user t where (t.id <3 and t.id = 1) or (t.id > 3110 and t.id = 3110) or t.id = 3000;
在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 则会发生冲突;