老问题,关于消除重复记录的问题
field1|field2|field3
客户1 |07-01-12 |事项1
客户1 |07-01-13 |事项2
客户2 |07-01-15 |事项3
客户4 |07-01-16 |事项4
要求只查出:
客户1 |07-01-13 |事项2
客户2 |07-01-15 |事项3
客户4 |07-01-16 |事项4
两条记录,就是只取日期最新的记录,该如何?
[解决办法]
select * from tablename a
where not exists (select 1 from tablename where field1 = a.field1 and field2 > a.field2)
[解决办法]
select * from tbName as A
where not exists(select 1 from tbName where field1=A.field1 and field2> A.field1)