INSERT INTO com_obstructionlogtmp
SELECT distinct * FROM com_obstructionlog GROUP BY dianlubh ORDER BY paichutime DESC
SELECT distinct * FROM com_obstructionlog GROUP BY dianlubh ORDER BY paichutime DESC
调试欢乐多
SELECT dianlubh,Max( time) FROM com_obstructionlog GROUP BY dianlubh
SELECT dianlubh,Max( time) FROM com_obstructionlog GROUP BY dianlubh
1 12 19347
2 12 12545
3 13 12348
4 13 10447
5 11 32145
6 11 23456...
...
...