Re: SQL HELP

Thanks guys. That takes care of it.

On 3/14/07, nike@xxxxxxxxxxxxxx <nike@xxxxxxxxxxxxxx> wrote:

Hi Bob,

select subac00001, count(*) table1 group by subacc00001 having count(*)=1

JD

Bob Bledsoe
> I have a file with field subac00001. I only want to select records that
> have
> no matching number in subac00001. for example from the records below i
> would
> only select 80989388. How do you do this with SQL?
>
> subac00001     field2
> 80989121        80,989,129
> 80989121        80,989,130
> 80989388        80,989,392
> 80989409        80,989,414
> 80989409        80,989,415
> 80989428        80,989,436
> 80989428        80,989,437
>
> Thanks, Bob B
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.