求助SQL查询语句

Question

select max (采购时间)min(采购时间) group by 采购时间

Answer 1

您刚才用的求最大值和最小值.但俩合返回的都是一样的数据
select a.vendorno,a.vendorname,min(a.receivedate),a.payeetype,b.itemno,b.orderprice,b.purprice from t_receive_h a,t_receive_d b
where a.receiveno=b.receiveno and a.payeetype like '2%' and a.vendorno<>'20441'
group by a.vendorno,a.vendorname,a.receivedate,a.payeetype,b.itemno,b.orderprice,b.purprice
order by a.receivedate
2003-12-31 09:07:42.967
2003-12-31 11:05:47.560
2003-12-31 11:05:47.560
2003-12-31 11:14:18.467
2003-12-31 11:14:18.467
2003-12-31 11:14:18.467
2003-12-31 11:14:18.467
2003-12-31 11:14:18.467
2003-12-31 11:33:56.560
2003-12-31 11:33:56.560select a.vendorno,a.vendorname,max(a.receivedate),a.payeetype,b.itemno,b.orderprice,b.purprice from t_receive_h a,t_receive_d b
where a.receiveno=b.receiveno and a.payeetype like '2%' and a.vendorno<>'20441'
group by a.vendorno,a.vendorname,a.receivedate,a.payeetype,b.itemno,b.orderprice,b.purprice
order by a.receivedate
2003-12-31 09:07:42.967
2003-12-31 11:05:47.560
2003-12-31 11:05:47.560
2003-12-31 11:14:18.467
2003-12-31 11:14:18.467
2003-12-31 11:14:18.467
2003-12-31 11:14:18.467
2003-12-31 11:14:18.467
2003-12-31 11:33:56.560