Results 1 to 5 of 5

Thread: guery

  1. #1
    Join Date
    Feb 2004
    Location
    Poland
    Posts
    96

    Unanswered: guery

    how to select the second row from query

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You'll have to order by something...

    The order of rows in a database are meaningless...

    GOT DDL?

    Hre'es a clue

    Code:
    USE Northwind
    GO
    
    sp_help Orders
    GO
    
    SELECT TOP 1 * FROM (
    SELECT TOP 2 * FROM Orders ORDER BY OrderId
    ) AS XXX ORDER BY OrderID DESC
    GO
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Feb 2004
    Location
    Poland
    Posts
    96
    Thanx but anyway
    I've overestimated myself

    What i need is here

    http://www.dbforums.com/t1023649.html

    Help

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by rafala
    I've overestimated myself
    Pronoun trouble....

    I wouldn't think so....

    OK, read the other thread...I'll go there...looks DAMN familiar though....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Feb 2004
    Location
    Poland
    Posts
    96
    no ideas ??????????

Posting Permissions

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