Microsoft SQL Server 2000:Create Row number into select query
Mention TableName and Primary key value in Below Query.
SELECT ( SELECT sum(1) FROM TableName T1
WHERE T1.PrimartKey <= T2.PrimaryKey
) AS [Row Number]
,*
FROM
TableName T2
Go
Use of Partition By.
SELECT *
FROM (
SELECT (
SELECT COUNT(*)
FROM #temp AS counter
WHERE counter.meterid = t.meterid --partiton key
AND counter.serial >= t.serial--order by key(identity column)
) AS rowNumber,*
FROM #temp t
) AS r1
where rownumber between 1 and 10
Use of Partition By.
SELECT *
FROM (
SELECT (
SELECT COUNT(*)
FROM #temp AS counter
WHERE counter.meterid = t.meterid --partiton key
AND counter.serial >= t.serial--order by key(identity column)
) AS rowNumber,*
FROM #temp t
) AS r1
where rownumber between 1 and 10
Comments
Post a Comment
Dear User,
Thank you very much for your kind response