[求助]求表内查询sql语句

lookice

表
id date salary
1  200805 100
1  200806 100
2  200805 100
2  200806 110
3  200805 100
3  200806 100
......
查200805和200806,salary工资不一致的id,date,salary

lqzlqz

用循环

9971gh

select * form 表 where date='200805'