sql查询某年某月的数据
USE [Dormitory ]
GO
SELECT [Eid]
,[Erid]
,[Eletoday]
,[Eledate]
FROM [dbo].[Electricity]
where year([Eledate])=2017 某年
GO
where month([Eledate])=3 某月
USE [Dormitory ]
GO
SELECT [Eid]
,[Erid]
,[Eletoday]
,[Eledate]
FROM [dbo].[Electricity]
where year([Eledate])=2017 某年
GO
where month([Eledate])=3 某月