USE [Dormitory ]GO
SELECT [Eid] ,[Erid] ,[Eletoday] ,[Eledate] FROM [dbo].[Electricity]
where year([Eledate])=2017 某年GO
where month([Eledate])=3 某月
posted on 2017-08-22 10:03 A欣 阅读(763) 评论(0) 编辑 收藏 举报