如表A:
riqi kehu jine
20120101 a 100.00
20120312 b 50.00
20120408 a 200.00
20120509 c 80.00
20120620 b 100.00
20120630 c 300.00
结果:
riqi kehu jine
20120408 a 200.00
20120620 b 100.00
20120630 c 300.00
jine没显示,请问要怎么加呢?谢谢
追答我改了,应该能显示的
select f. kehu, f.riqi , A.jine from ( select kehu, max(riqi) riqi from A group by kehu ) f, A where f.kehu = A.kehu and f.riqi = A.riqi