ROW_NUMBER()

Posted Date: 30 Nov 2008	Resource Type: Code Snippets	Category: SQL
Author: Arun Jacob	Member Level: Gold
Rating:	Points: 3

ROW_NUMBER() is using for retrieving the row numbers just like displaying in the result pane.


Select * from
(Select *,ROW_NUMBER() OVER(ORDER BY EmployeeID)  as RowNumber from Employee)Temp
where RowNumber BETWEEN 2 AND 4

:-)

Responses

Author: Fool To Code 02 Dec 2008 Member Level: Gold Points : 0

thanx dude, it may solve many problems

Feedbacks

Popular Tags

What are tags ?

Search Tags

ROW_NUMBER() .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: JOINS in SQL
	Previous Resource: Writting a CLR Stored Proc
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

JOINS in SQL
Import data directly from excel into SQL Server
Convert Amount in Words using SQL Function
Store and retrieve file with SQL Server
connection to sql server with connected architecture
Simple stored procedure for insertion