ADD COLUMN VALUE

Question

Hello Sir... I am working in SQLSERVER and i want to add column value like i have a one table id, salary and i want to output id, add salary like first to second, second to third value?

Bhasker Das · Answer

Hi Davin, Try this - Generate Sample Table with Records ----------------------------------------- CREATE TABLE [dbo] . [UserTable] ( [ID] [int] NOT NULL, [Name] [varchar] ( 50 ) NULL, [Mobile] [varchar] ( 15 ) NULL, [Salary] [bigint] NULL, CONSTRAINT [PK_UserTable] PRIMARY KEY CLUSTERED ( [ID] ASC ) WITH ( PAD_INDEX = OFF , STATISTICS_NORECOMPUTE = OFF , IGNORE_DUP_KEY = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO INSERT [dbo] . [UserTable] ( [ID] , [Name] , [Mobile] , [Salary] ) VALUES ( 1 , N'Bhasker' , N'1236547893' , 10000 ) INSERT [dbo] . [UserTable] ( [ID] , [Name] , [Mobile] , [Salary] ) VALUES ( 5 , N'Shiv' , N'8523698741' , 20000 ) INSERT [dbo] . [UserTable] ( [ID] , [Name] , [Mobile] , [Salary] ) VALUES ( 8 , N'Davin' , N'8546987456' , 30000 ) INSERT [dbo] . [UserTable] ( [ID] , [Name] , [Mobile] , [Salary] ) VALUES ( 10 , N'Sanjay' , N'3214469856' , 40000 ) ----------------------------------- Now run below script to get your desired output - SELECT SUM ( ISNULL ( A . Salary , 0 ) + ISNULL ( B . Salary , 0 )) [Cumulative Salary] , A . [Computed ID] FROM ( SELECT ROW_NUMBER () Over ( Order By ID ) AS [Computed ID] , Salary FROM UserTable ) AS A LEFT JOIN ( SELECT ROW_NUMBER () Over ( Order By ID ) AS [Computed ID] , Salary FROM UserTable ) AS B on A . [Computed ID] = B . [Computed ID] + 1 Group By A . [Computed ID] , A . Salary , B . Salary

Khan Abrar Ahmed · Answer

Hi try this script DECLARE @table AS TABLE ( id INT, salary MONEY ); DECLARE @tableOutput AS TABLE ( RowID INT, salary MONEY ); DECLARE @COUNT INT = 0 , @maxcount INT= 1 INSERT INTO @table VALUES ( 1, 1000 ), ( 2, 3000 ), ( 3, 4000 ) SELECT @count = COUNT(1) FROM @table AS t DECLARE @totalSum MONEY SELECT * FROM @table AS t WHILE @COUNT >= @maxcount BEGIN IF ( @maxcount = 1 ) BEGIN SELECT @totalSum = salary FROM @table AS t WHERE id = @maxcount END ELSE BEGIN SELECT @totalSum = SUM(salary) FROM @table AS t2 WHERE id = @maxcount; SELECT @totalSum = @totalSum + salary FROM @tableOutput AS t WHERE Rowid IN ( @maxcount, @maxcount - 1 ) END INSERT INTO @tableOutput ( RowID, salary ) VALUES ( @maxcount, -- RowID - int @totalSum -- salary - money ) SET @maxcount += 1; END SELECT * FROM @tableOutput;

Ankur Jain · Answer

Hi!, this query works for you...please don't forget to mark it answer if it solve your problem... Use Demo Go declare @totalrows int select @totalrows = COUNT(*) from UserDetails CREATE TABLE #EMploy ( ID int IDENTITY, Salary int ) declare @currentrow int = 1 declare @prev int declare @next int declare @total int while @currentrow begin select @prev = Salary from UserDetails where ID = @currentrow set @currentrow = @currentrow + 1 select @next = Salary from UserDetails where ID = @currentrow set @total = @prev +@next insert into #EMploy (Salary) values(@total) end select * from #EMploy

Davin Martyn · Answer

like table id salary 1 10000 2 30000 3 40000 out put id salary 1 10000 2 40000 3 80000 i want to these output

Bhasker Das · Answer

Please write down the format if you can. Would help us to understand output.

ADD COLUMN VALUE

Answers (5)