Comments on Why???

From: Christine Turner <christine.turner_at_ips-sendero.com>
Date: Fri, 28 Jul 2000 05:08:50 -0700
Message-Id: <10572.113217@fatcity.com>

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 Received on Fri Jul 28 2000 - 07:08:50 CDT