CREATE TABLE [dbo].[Rownumber](
[Name] [varchar](50) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[Rownumber] ([Name]) VALUES ('Gaurav')
GO
INSERT [dbo].[Rownumber] ([Name]) VALUES ('Sudeep')
GO
INSERT [dbo].[Rownumber] ([Name]) VALUES ('Kishor')
GO
INSERT [dbo].[Rownumber] ([Name]) VALUES ('Santosh')
GO
I DNT WANT ABOVE OUT PUT, I WANT BELOW OUT PUT.....LETS TRY THIS
This is the Query for this output:
SELECT Name,
ROW_NUMBER() OVER(ORDER BY (SELECT 0)) AS InsertOrderRowNumber
FROM Rownumber
No comments:
Post a Comment