Re: SQL - selecting issue

[Alfredo Delgado <adelgado@xxxxxxxxxxxxxxxxx>]

This worked for me on the test data you provided:

SELECT Premise, Meter
FROM ALFREDLIB.PREMISE
GROUP BY Premise, Meter
HAVING count( Sequence ) > 1

Thanks,
Alfred

Smith, Mike wrote:

> Charles,
> Yes I must have had a typo of some sort.  I copied from your last email
> and it is working and working and working.  I'm still waiting on
> results.   This may work, but I'm not sure it is going to be the
> ultimate solution.  My file has approximately 67,000 records.  
> This was a recent copy as it still keeps on going- much like the
> energizer bunny.   
> Query running. 0 records selected, 28788150 processed. 
>
> Michael Smith
> iSeries.mySeries.
>
>