CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. April 28th, 2005, 11:53 PM #1
    nvinoth123
    nvinoth123 is offline Member
    Join Date
    Sep 2003
    Posts
    60

    Need a particular row value from table.

    Hi,
    How do i get the nth row value in a table in sql server. For example i wanted a particular field value of the 10 row in a table how do i get it. is there any query for that. Please help me out in this.Thanks in advance.
    Regards
    Vinoth
    Reply With Quote Reply With Quote
  2. April 29th, 2005, 04:14 AM #2
    Krzemo
    Krzemo is offline Senior Member
    Join Date
    Nov 2004
    Location
    Poland
    Posts
    1,355

    Re: Need a particular row value from table.

    Code:
     DECLARE @field INT 
 
SELECT top 10 @field=field from MyTable
SELECT @field field
    Hope that helps
    Reply With Quote Reply With Quote
  3. July 14th, 2005, 12:10 PM #3
    Hank247
    Hank247 is offline Junior Member
    Join Date
    Jul 2005
    Posts
    1

    Re: Need a particular row value from table.

    How would one do this in Access 2002?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured