The person wanted to make sure he was selecting unique
(gl_acct_no), (description) .
People documenting what they do is an endangered
species.
- Christine Turner
<christine.turner_at_ips-sendero.com> a écrit : > Good
Morning All....
>
> Working on something someone else wrote and maybe
> I'm missing the obvious.
> But would anyone have any idea as to why someone
> would use the rowid in this
> query????
>
> insert into temp_big_gllist (glacct, desct)
> select distinct (gl_acct_no), (description)
> from gene310 t1 where t1.rowid =
> (select min(t2.rowid)
> from gene310 t2
> where t1.gl_acct_no = t2.gl_acct_no);
>
> I'm having a hard time understanding why someone
> would do this and of course
> there are no notes left behind to explain. Anyone
> else have any ideas????
>
> Thanks In Advance!!
> Take Care,
> Christine Turner
> DBA
> IPS SENDERO
> Scottsdale, Arizona
>
> --
> Author: Christine Turner
> INET: christine.turner_at_ips-sendero.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
Received on Fri Jul 28 2000 - 08:13:03 CDT
