分组取最小时间的记录,急啊

[dd_zhouqian]

select d.make_number,d.actual_pay_money,min(d.Deal_Date) from t_cash_info d
group by d.make_number,d.actual_pay_money
查询的所有记录如下:
HZMDD HZMDDCN00001 001 HZMDDEE00001 现金 300.0 300.0 300.0 0.0 0.0 0.0 0.0 HZMDDMN00001 2005-09-27 00:00:00.000
HZMDD HZMDDCN00002 001 HZMDDEE00001 现金 500.0 10000.0 500.0 0.0 0.0 0.0 9500.0 HZMDDMN00002 2005-09-27 00:00:00.000
HZMDD HZMDDCN00003 001 HZMDDEE00001 现金 6000.0 9500.0 5000.0 0.0 0.0 0.0 4500.0 HZMDDMN00002 2005-09-28 00:00:00.000
HZMDD HZMDDCN00004 001 HZMDDEE00001 现金 15000.0 4500.0 4000.0 0.0 0.0 0.0 500.0 HZMDDMN00002 2005-09-28 00:00:00.000
HZMDD HZMDDCN00005 001 HZMDDEE00001 现金 19500.0 500.0 500.0 0.0 0.0 0.0 0.0 HZMDDMN00002 2005-09-28 00:00:00.000
HZMDD HZMDDCN00006 001 HZMDDEE00001 现金 100.0 10000.0 100.0 0.0 0.0 0.0 9900.0 HZMDDMN00004 2005-09-28 00:00:00.000
HZMDD HZMDDCN00007 001 HZMDDEE00001 现金 300.0 9900.0 100.0 0.0 0.0 0.0 9800.0 HZMDDMN00004 2005-09-28 00:00:00.000
用以上sql查询的结果都不符合要求:
HZMDDMN00004 100.0 2005-09-28 00:00:00.000
HZMDDMN00001 300.0 2005-09-27 00:00:00.000
HZMDDMN00002 500.0 2005-09-27 00:00:00.000
HZMDDMN00002 4000.0 2005-09-28 00:00:00.000
HZMDDMN00002 5000.0 2005-09-28 00:00:00.000
分析可能是sql的bug,如果在同一天结果是符合要求的,但如果不是同一天的,那么不正确.

[dd_zhouqian]

没有人会吗?解决立即给分啊

[pjy998]

回复人： lxzm1001(*蓝星之梦*) ( ) 信誉：100 2005-09-29 00:21:00 得分: 0


查询加一个 distinct
select distinct d.* from d,(select col1 as col4,min(col3) as col5 from d group by col1) t where col1=t.col4 and col3=t.col5



這個可以。

[lxzm1001]

create table d
(col int,
col2 money,
col3 datetime)
insert d values(4,100,'2005-9-28')
insert d values(1,300,'2005-9-27')
insert d values(2,500,'2005-9-27')
insert d values(2,4000,'2005-9-28')
insert d values(2,5000,'2005-9-28')
insert d values(4,600,'2005-9-29')
select d.* from d,(select col1 as col4,min(col3) as col5 from d group by col1) t where col1=t.col4 and col3=t.col5

[lxzm1001]

查询加一个 distinct
select distinct d.* from d,(select col1 as col4,min(col3) as col5 from d group by col1) t where col1=t.col4 and col3=t.col5

[iwl]

你要的什么结果