数据库问题，急~~~(100分)

card date money remain type
------------------------------------------------------------
1 0055503116 2008-02-01 00:25:00 890.00 0 卡付
2 0055503116 2008-02-01 00:25:00 890.00 500 现金
3 0055502967 2008-02-01 05:41:00 180.00 320 卡付
4 0055503001 2008-02-01 06:23:00 100.00 64 卡付
5 0055503118 2008-02-01 14:17:00 504.00 0 卡付
6 0055503118 2008-02-01 14:17:00 504.00 500 现金


有这样的一个数据表，我主要是要money 字段的值，但是当碰到1和2，5和6这样的重复数据时，则要提取type=现金 的那条数据的remain字段值而不取money 字段值，并且要过滤掉remain为0的数据， 帮帮忙啊各位，急啊

select card,date,money,remain,type from table_name where
card not in (select distinct card from table_name
group by card
having count(card)>1)
union all
select card,date,money,remain,type from table_name
where card in (select distinct card from table_name
group by card
having count(card)>1) and remain<>0 and type='现金'

接受答案了.