dcsimg
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12
  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!


  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

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




×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.