CREATE TABLE [dbo].[Test](
[DocEntry] [int] NOT NULL,
[Itemcode] [nvarchar](50) NULL,
[Linetotal] [numeric](19, 6) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[Test] ([DocEntry], [Itemcode], [Linetotal]) VALUES (34676, N'2560209620', CAST(15400.000000 AS Numeric(19, 6)))
GO
INSERT [dbo].[Test] ([DocEntry], [Itemcode], [Linetotal]) VALUES (34676, N'2560512620', CAST(7700.000000 AS Numeric(19, 6)))
GO
INSERT [dbo].[Test] ([DocEntry], [Itemcode], [Linetotal]) VALUES (34676, N'2690001820', CAST(9800.000000 AS Numeric(19, 6)))
GO
INSERT [dbo].[Test] ([DocEntry], [Itemcode], [Linetotal]) VALUES (34677, N'2560900320', CAST(5960.000000 AS Numeric(19, 6)))
GO
INSERT [dbo].[Test] ([DocEntry], [Itemcode], [Linetotal]) VALUES (34677, N'2560901520', CAST(4040.000000 AS Numeric(19, 6)))
GO
INSERT [dbo].[Test] ([DocEntry], [Itemcode], [Linetotal]) VALUES (34677, N'2580100220', CAST(3260.000000 AS Numeric(19, 6)))
GO
doc itemcode linetotal
34676 2560209620 15400.000000
34676 2560512620 7700.000000
34676 2690001820 9800.000000
34677 2560900320 5960.000000
34677 2560901520 4040.000000
34677 2580100220 3260.000000
I want output like below
doc itemcode linetotal
34676 2560209620 15400.000000
2560512620 7700.000000
2690001820 9800.000000
34677 2560900320 5960.000000
2560901520 4040.000000
2580100220 3260.000000