RE: SQL - selecting issue

Charles, 

Just for my clarification, can you explain why you're going through the CTE
gyrations? A simple select distinct or select group by should satisfy Mike's
request.

select * from loyd/mike
PREMISE  SEQ   METER
   X       1   9,999
   X       2   9,999
   Y       1   9,998
   Y       2   9,998
   Z       1   9,999

select distinct premise, meter from loyd/mike
PREMISE  METER
   X     9,999
   Y     9,998
   Z     9,999

select distinct premise, meter from loyd/mike
where meter=9999
PREMISE  METER
   X     9,999
   Z     9,999

select premise, meter from loyd/mike 
group by premise, meter
PREMISE  METER
   X     9,999
   Y     9,998
   Z     9,999

select premise, meter from loyd/mike
where meter=9999 group by premise, meter
PREMISE  METER
   X     9,999
   Z     9,999



Loyd Goodbar
Senior programmer/analyst
BorgWarner
E/TS Water Valley
662-473-5713

-----Original Message-----
From: Wilt, Charles [mailto:CWilt@xxxxxxxxxxxx] 
Sent: Wednesday, October 04, 2006 07:51
To: Midrange Systems Technical Discussion
Subject: RE: SQL - selecting issue

Mike,

You must have a type or something as I know CTE's worked on v5r3.

<snip>