Re: SQL break ?

Hi Matt, I added the group by but I get the same results.




-----Original Message-----
From: Matt Olson <Matt.Olson@xxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Fri, Mar 15, 2013 3:55 pm
Subject: RE: SQL break ?


Add a group by.
SELECT RDDTNM, RDRSET, RDRPTN FROM REPRD
ROUP BY RDDTNM,RDRSET,RDRPTN
RDER BY rddtnm
-----Original Message-----
rom: fbocch2595@xxxxxxx [mailto:fbocch2595@xxxxxxx]
ent: Friday, March 15, 2013 2:40 PM
o: midrange-l@xxxxxxxxxxxx
ubject: SQL break ?

i Folks, when I run this statement;
SELECT RDDTNM, RDRSET, RDRPTN FROM REPRD ORDER BY rddtnm I get the screen
elow but how can I remove the duplicate names and only show one name for every
eport set? I know it's doable with wrkqry but I'd like to use SQL.
Thanks, Frank
DTNM REPORT SET NAME REPORT NAME
ALEX KAPILF ALLITARB4 ALLITARB4
ANDREW LAJR C34TIPPFZ2 C34TIPPFZ2
ANDREW LAJR X12CVMSF X12CVMSF
ANN MCKE P08RATRF P08RATRF
ANN MCKE C36TIPPF C36TIPPF
ANN MCKE D75LEINF D75LEINF
ANN MCKE P88MAILF P88MAILF
ANN MCKE QSYSPRTX QSYSPRTX
ANN MCKE X24RCVMF X24RCVMF
ANN MCKE P09DUPLF P09DUPLF
ANNE MULDEG C01CAXF C01CAXF
ANNE MULDEG C01DETF C01DETF
ANNE MULDEG C03EMPLF C03EMPLF
ANNE MULDEG C12EMPLF C12EMPLF
ANNE MULDEG C17LOSSF C17LOSSF
ANNE MULDEG C23CLEXF C23CLEXF
ANNE MULDEG C23CLSSF C23CLSSF
ANNE MULDEG C25NODTF C25NODTF
ANNE MULDEG C35TIPPF C35TIPPF

--
his is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To
ost a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
hange list options,
isit: http://lists.midrange.com/mailman/listinfo/midrange-l
r email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment
o review the archives at http://archive.midrange.com/midrange-l.