有大神帮忙看下吗?本月合计,本年合计问题
类似财务账本的显示
CREATE TABLE [dbo].[stockin](
[fdate] [datetime] NULL,
[fitemname] [varchar](100) NULL,
[fqtyin] [decimal](18, 2) NULL,
[fqtyou] [decimal](18, 2) NULL,
[fmonth] [datetime] NULL,
[fday] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[stockin] ([fdate], [fitemname], [fqtyin], [fqtyou], [fmonth], [fday]) VALUES (CAST(0x000092F600000000 AS DateTime), N'AAA', CAST(125.00 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), CAST(0x00009312018B80D4 AS DateTime), CAST(0x00009312018B7FA8 AS DateTime))
INSERT [dbo].[stockin] ([fdate], [fitemname], [fqtyin], [fqtyou], [fmonth], [fday]) VALUES (CAST(0x000092FD00000000 AS DateTime), N'AAA', CAST(120.00 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), CAST(0x00009312018B80D4 AS DateTime), CAST(0x00009312018B7FA8 AS DateTime))
INSERT [dbo].[stockin] ([fdate], [fitemname], [fqtyin], [fqtyou], [fmonth], [fday]) VALUES (CAST(0x0000930000000000 AS DateTime), N'BBB', CAST(-20.00 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), CAST(0x00009312018B80D4 AS DateTime), CAST(0x00009312018B7FA8 AS DateTime))
INSERT [dbo].[stockin] ([fdate], [fitemname], [fqtyin], [fqtyou], [fmonth], [fday]) VALUES (CAST(0x0000931100000000 AS DateTime), N'AAA', CAST(25.00 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), CAST(0x00009312018B80D4 AS DateTime), CAST(0x00009312018B7FA8 AS DateTime))
INSERT [dbo].[stockin] ([fdate], [fitemname], [fqtyin], [fqtyou], [fmonth], [fday]) VALUES (CAST(0x0000931500000000 AS DateTime), N'BBB', CAST(100.00 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), CAST(0x0000932E018B80D4 AS DateTime), CAST(0x0000932E018B7FA8 AS DateTime))
INSERT [dbo].[stockin] ([fdate], [fitemname], [fqtyin], [fqtyou], [fmonth], [fday]) VALUES (CAST(0x0000933300000000 AS DateTime), N'CCC', CAST(120.00 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), CAST(0x0000934D018B80D4 AS DateTime), CAST(0x0000934D018B7FA8 AS DateTime))
求每月的本月合计,每个月下面追加本年合计

该如何用SQL实现呢??大神求帮忙!!!万分感谢!
CREATE TABLE [dbo].[stockin](
[fdate] [datetime] NULL,
[fitemname] [varchar](100) NULL,
[fqtyin] [decimal](18, 2) NULL,
[fqtyou] [decimal](18, 2) NULL,
[fmonth] [datetime] NULL,
[fday] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[stockin] ([fdate], [fitemname], [fqtyin], [fqtyou], [fmonth], [fday]) VALUES (CAST(0x000092F600000000 AS DateTime), N'AAA', CAST(125.00 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), CAST(0x00009312018B80D4 AS DateTime), CAST(0x00009312018B7FA8 AS DateTime))
INSERT [dbo].[stockin] ([fdate], [fitemname], [fqtyin], [fqtyou], [fmonth], [fday]) VALUES (CAST(0x000092FD00000000 AS DateTime), N'AAA', CAST(120.00 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), CAST(0x00009312018B80D4 AS DateTime), CAST(0x00009312018B7FA8 AS DateTime))
INSERT [dbo].[stockin] ([fdate], [fitemname], [fqtyin], [fqtyou], [fmonth], [fday]) VALUES (CAST(0x0000930000000000 AS DateTime), N'BBB', CAST(-20.00 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), CAST(0x00009312018B80D4 AS DateTime), CAST(0x00009312018B7FA8 AS DateTime))
INSERT [dbo].[stockin] ([fdate], [fitemname], [fqtyin], [fqtyou], [fmonth], [fday]) VALUES (CAST(0x0000931100000000 AS DateTime), N'AAA', CAST(25.00 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), CAST(0x00009312018B80D4 AS DateTime), CAST(0x00009312018B7FA8 AS DateTime))
INSERT [dbo].[stockin] ([fdate], [fitemname], [fqtyin], [fqtyou], [fmonth], [fday]) VALUES (CAST(0x0000931500000000 AS DateTime), N'BBB', CAST(100.00 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), CAST(0x0000932E018B80D4 AS DateTime), CAST(0x0000932E018B7FA8 AS DateTime))
INSERT [dbo].[stockin] ([fdate], [fitemname], [fqtyin], [fqtyou], [fmonth], [fday]) VALUES (CAST(0x0000933300000000 AS DateTime), N'CCC', CAST(120.00 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), CAST(0x0000934D018B80D4 AS DateTime), CAST(0x0000934D018B7FA8 AS DateTime))
求每月的本月合计,每个月下面追加本年合计

该如何用SQL实现呢??大神求帮忙!!!万分感谢!
...全文
相关推荐
java 获取时间 本周本年本月第一天最后一天
Calendar c = new GregorianCalendar(); c.setFirstDayOfWeek(Calendar.MONDAY); c.setTime(new Date()); c.set(Calendar.DAY_OF_WEEK, c.getFirstDayOfWeek()); // Monday System.out.println(c.getTime()); c.set(Calendar.DAY_OF_WEEK, c.getFirstDayOfWeek() + 6); // Sunday //本周第一天,以星期日开始 。。。。。。。。。。。。。。。 //本月第一天
C#中的DateTime:本周,本月,本年,本周第一天
C#中的DateTime:本周,本月,本年,本周第一天
sql server 查询当天,本周,本月,本年,30天内的数据的sql语句
sql server 查询当天,本周,本月,本年,30天内的数据的sql语句
Sql语句 查询本周记录\本月记录\本季度记录\本年记录
查询本周记录\本月记录\本季度记录\本年记录等的SQL语句 分Mysql 和SQL Server 查询语句。 有效率的查询语句。
sql 查询本年、本月、本日记录的语句,附SQL日期函数
sql 查询本年、本月、本日记录的语句,附SQL日期函数,学习sql的朋友可以参考下。


疑难问题
