sql语法

SELECT *,SUM(b.qty) OVER(PARTITION BY b.billno ORDER BY b.rkdate ROWS UNBOUNDED PRECEDING) AS qtyresult,total-SUM(b.qty) OVER(PARTITION BY b.billno ORDER BY b.rkdate ROWS UNBOUNDED PRECEDING) 剩余数量 FROM a_test b

CREATE TABLE [dbo].[a_test](
    [id] [int] NOT NULL,
    [billno] [varchar](255) NULL,
    [qty] [money] NULL,
    [aje] [money] NULL,
    [total] [money] NULL,
    [rkdate] [date] NULL,
PRIMARY KEY CLUSTERED 
(
    [id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]