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! > >
