Question

MYSQL如何在同一个表查询字段1与字段2的记录不相同记录?

我有个表cq_cc,表有c1和c2两个字段.记录的都是数值.我现在想查询出c1和c2段不相同的记录找出来.要怎么写语句?

Answer 1

select * from cq_cc where c1<>c2
希望对你有帮助

Answer 2

select * from cq_cc where c1!=c2 ;

Answer 3

SELECT * FORM cq_cc WHERE c1<>c2;

Answer 4

select * from cq_cc where c1<>c2