Select statement - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Select statement

  1. #11
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    This would be more appropriate in the development forum rather than being in the administration. So I'm taking the liberty to move this thread to the development forum from the administration forum


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!

    Share on Google+

  2. #12
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    While I applaud the general approach of the solution, I would argue against its usage of ROWID. IMHO, ROWID should never be used in production SQL.

    I might suggest the following instead:

    select contract_number,col_1,col_2,col_3,...,col_n
    from the_table a
    where CCode || ' ' || DCode || ' ' || LocationCode
    =(select min(CCode || ' ' || DCode || ' ' || LocationCode )
    from the_table
    where contract_number=a.contract_number);

    Anyway, just a thought,

    - Chris
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong
    Share on Google+

Posting Permissions

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


Click Here to Expand Forum to Full Width