- 博客(2)
- 资源 (2)
- 收藏
- 关注
RSS订阅原创 工作随笔--取出日数据
select Stcd,convert(varchar(10),tm,120) ym,tm,GWL into DaYtemp from GW_WLH_R select Stcd,ym,max(GWL)MaxGWL,min(GWL) MinGWL,avg(convert(decimal(6, 2),GWL)) avgdate into DaYtemp1 from DaYtemp group by Stcd,ym order by StcdSELECT a.STCD, a.maxGWL
2010-06-11 11:52:00
189
原创 sql从日数据中提取月数据
<br />原始表：<br /> if exists (select 1 from sysobjects where name='test1')drop table test1gocreate table test1 ( id varchar(10), Tm datetime,data varchar(20) ) insert into test1 select '01','2010-01-01 ','10' insert into test1 select '
2010-06-10 17:18:00
536
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人