SQL语句查询,请帮忙!
如表A中查询出丢失存款金额流水行的工号。
表A:
peono date consumemoney fundmoney surplusmoney
0002 2007-01-01 09:59:33.000 0.00 100.00 100.00
0001 2007-01-01 10:59:33.000 0.00 100.00 100.00
0003 2007-01-01 13:59:33.000 0.00 100.00 100.00
0003 2007-01-02 08:59:33.000 8.00 0.00 92.00
0001 2007-01-02 11:23:33.000 2.00 0.00 98.00
0002 2007-01-02 16:59:33.000 2.00 0.00 98.00
0003 2007-01-03 11:59:33.000 2.00 0.00 140.00
0001 2007-01-03 14:59:33.000 5.00 0.00 93.00
0002 2007-01-03 18:59:33.000 4.00 0.00 194.00
0002 2007-01-04 07:59:33.000 2.00 0.00 192.00
0001 2007-01-04 08:59:33.000 2.00 0.00 91.00
0003 2007-01-04 12:59:33.000 3.00 0.00 137.00
0002 2007-01-05 13:59:33.000 4.00 0.00 188.00
0001 2007-01-05 17:59:33.000 2.00 0.00 89.00
0003 2007-01-05 19:59:33.000 4.00 0.00 233.00
0003 &