如何将两个值相加 [英] how to sum two values

问题描述

我在sqlserver中有两列表格列名称是receiptno和amount。

如果我有两个receiptno'和金额200和300.now我想要receiptno = 2,3

和金额= 500怎么可能。请尽快帮助我

i have two columns in sqlserver in a table columns names are receiptno and amount.
if i have two receiptno''s and amounts 200 and 300.now i want receiptno=2,3
and amount=500 how it can be possible.please help me as soon as possible

推荐答案

查询：

Query:

SELECT  STUFF(
               (SELECT      ',' + Cast (recno as varchar(10))
               FROM     test
               FOR XML PATH('')), 1, 1, '') AS RecceiptNumbers,sum(amount) FROM test

我的桌子结构

My table structure

create table test
(recno int,
amount decimal)

INSERT INTO test VALUES (3,300)

SELECT  STUFF(
               (SELECT      ',' + Cast (recno as varchar(10))
               FROM     test
               FOR XML PATH('')), 1, 1, '') AS RecceiptNumbers,sum(amount) FROM test

这篇关于如何将两个值相加的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！