刚才理解错了,不好意思!
我试了一下SQL,没成功。写个存储过程对付一下。if exists (select * from sysobjects where id = object_id('dbo.midate') and sysstat & 0xf = 4)
drop procedure dbo.midate
GOCREATE PROCEDURE midate AS
create table #bmtmp(bm int not null,date smalldatetime not null)
insert #bmtmp select bm,min(date) from mybm group by bm
select mybm.bm,min(mybm.sdj) from mybm,#bmtmp where mybm.bm=#bmtmp.bm and mybm.date=#bmtmp.date group by mybm.bmGO
我试了一下SQL,没成功。写个存储过程对付一下。if exists (select * from sysobjects where id = object_id('dbo.midate') and sysstat & 0xf = 4)
drop procedure dbo.midate
GOCREATE PROCEDURE midate AS
create table #bmtmp(bm int not null,date smalldatetime not null)
insert #bmtmp select bm,min(date) from mybm group by bm
select mybm.bm,min(mybm.sdj) from mybm,#bmtmp where mybm.bm=#bmtmp.bm and mybm.date=#bmtmp.date group by mybm.bmGO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货