RE: SQL break ?

This will probably work for you.
As long as you are above v5r4

With rowcount as (
SELECT RDDTNM, RDRSET, RDRPTN, ROW NUMBER() OVER(PARTITION BY RDDTNM ORDER BY RDDTNM, RDRSET, RDRPTN) as rowno
FROM REPRD
ORDER BY RDDTNM)

Select CASE ROWNO when 1 then RDDTNM else '' end, RDRSET, RDRPTN from rowcount


-Tom Stieger
IT Manager
California Fine Wire



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of fbocch2595@xxxxxxx
Sent: Friday, March 15, 2013 12:40 PM
To: midrange-l@xxxxxxxxxxxx
Subject: SQL break ?


Hi Folks, when I run this statement;

SELECT RDDTNM, RDRSET, RDRPTN FROM REPRD ORDER BY rddtnm I get the screen below but how can I remove the duplicate names and only show one name for every report 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



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