you can use ROW_NUMBER() function with OVER clause such as:
USE AdventureWorks;
GO
SELECT c.FirstName, c.LastName
,ROW_NUMBER() OVER(ORDER BY SalesYTD DESC) AS 'Row Number'
,s.SalesYTD
FROM Sales.SalesPerson s
INNER JOIN Person.Contact c
ON s.SalesPersonID = c.ContactID
for more details check SQL Server books online
Regards,
Abul Hasan
2009/9/4 Andrew Badera <[email protected]>
>
> There is no such thing.
>
> You can get the row's primary key value. You can use ROW_NUMBER in
> your statements to arbitrarily assign a row number, but there's no
> intrinsic "row number" by default.
>
> You can also use "SELECT TOP 5" to get the first 5 results of a query,
> and use the fifth result ..
>
> ∞ Andy Badera
> ∞ +1 518-641-1280
> ∞ This email is: [ ] bloggable [x] ask first [ ] private
> ∞ Google me:
> http://www.google.com/search?q=(andrew+badera)+OR+(andy+badera)
>
>
>
> On Fri, Sep 4, 2009 at 9:12 AM, san<[email protected]> wrote:
> > How can i get the row number in which record is stored in sql server.
> >
> > Example: suppose if record is stored in fifth row i want output as 5.
> >
> > Thanks!
> >
> >
>
--
Abul Hasan Lakhani
