按日分组:select DATE_FORMAT(o.OrderDate,'%Y%m%d') weeks,count(*) count from orders o group by weeks; 按月分组:select DATE_FORMAT(o.OrderDate,'%Y%m') weeks,count(*) count from orders o group by weeks; 按周分
一个简单进销存系统按日的库存 一下是数据库表结构 以下是结果 ALTER PROC dbo.proc_StokcWithDate @StartDate DATE,@EndDate DATE,@PartNumQuery NVARCHAR(200)ASBEGINSELECTtt.Date,CAST(0 AS DECIMAL(18, 5)) AccInQty,CAST(0 AS DEC