Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » select max value in date(select max value in date)
select max value in date [message #1729739] Mon, 18 April 2016 11:37 Go to next message
Eclipse UserFriend
hello i want to select the max value in a date:

i have:

CIUSMD NMISMD LTESMH QSFSMH DTVSLT TPRDPR DTPDPR PREC_MAX
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 LM 20130507 92.0
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 LM 20121106 89.0
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 LM 20121009 86.0
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 LM 20120904 86.0
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 LM 20120820 86.0
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 MD 20130507 93.0
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 MD 20130404 92.0
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 MD 20121210 91.0
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 MD 20121106 89.0
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 MD 20121026 86.85
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 MD 20120610 86.0
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20160105 49.321
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20150505 62.946
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20150428 62.64
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20150423 62.946
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20150305 62.64
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20140613 78.13
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20130705 78.12
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20130506 73.43
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20130423 78.49
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20121003 73.43
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20121002 73.08
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20120912 73.43
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20120911 73.78
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20120907 73.43
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20120906 73.78
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20120905 73.78
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20120831 73.43
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20120824 73.78
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20120821 73.43
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20120817 73.43
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20120816 73.78
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20120518 73.78
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20120301 72.89
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20120201 78.49
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20120101 78.49

In this case the resull should be:

5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 MD 20130507 93.0

in this case:

CIUSMD NMISMD LTESMH QSFSMH DTVSLT TPRDPR DTPDPR PREC_MAX
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 DP 20160223 5.1
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 DP 20160223 5.1
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 DP 20160223 5.1
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 DP 20160223 5.1
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 DP 20160223 5.1
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 DP 20160223 5.1
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 DP 20160223 5.1
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 DP 20151026 5.94
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 DP 20151026 5.94
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 DP 20151026 5.94
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 DP 20151026 5.94
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 DP 20151026 5.94
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 DP 20151026 5.94
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 DP 20151026 5.94
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 MD 20160321 5.6
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 MD 20160321 5.6
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 MD 20160321 5.6
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 MD 20160321 5.6
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 MD 20160321 5.6
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 MD 20160321 5.6
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 MD 20160321 5.6
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20160105 4.73
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20160105 4.73
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20160105 4.73
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20160105 4.73
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20160105 4.73
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20160105 4.73
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20160105 4.73
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150505 5.572
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150505 5.572
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150505 5.572
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150505 5.572
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150505 5.572
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150505 5.572
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150505 5.572
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150429 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150429 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150429 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150429 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150429 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150429 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150429 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150423 5.572
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150423 5.572
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150423 5.572
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150423 5.572
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150423 5.572
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150423 5.572
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150423 5.572
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150415 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150415 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150415 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150415 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150415 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150415 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150415 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150331 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150331 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150331 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150331 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150331 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150331 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150331 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150303 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150303 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150303 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150303 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150303 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150303 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150303 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150228 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150228 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150228 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150228 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150228 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150228 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150228 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150220 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150220 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150220 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150220 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150220 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150220 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150220 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150214 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150214 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150214 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150214 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150214 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150214 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150214 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150213 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150213 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150213 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150213 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150213 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150213 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150213 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150209 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150209 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150209 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150209 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150209 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150209 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150209 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150207 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150207 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150207 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150207 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150207 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150207 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150207 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150131 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150131 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150131 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150131 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150131 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150131 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150131 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150130 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150130 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150130 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150130 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150130 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150130 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150130 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150126 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150126 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150126 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150126 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150126 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150126 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150126 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150123 3.39
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150123 3.39
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150123 3.39
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150123 3.39
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150123 3.39
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150123 3.39
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150123 3.39
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150112 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150112 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150112 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150112 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150112 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150112 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150112 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20150110 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20150110 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20150110 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20150110 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20150110 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20150110 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20150110 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20141222 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20141222 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20141222 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20141222 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20141222 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20141222 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20141222 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20141221 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20141221 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20141221 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20141221 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20141221 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20141221 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20141221 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20141217 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20141217 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20141217 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20141217 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20141217 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20141217 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20141217 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20141213 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20141213 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20141213 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20141213 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20141213 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20141213 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20141213 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20140901 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20140901 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20140901 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20140901 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20140901 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20140901 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20140901 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20140830 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20140830 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20140830 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20140830 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20140830 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20140830 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20140830 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20140527 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20140527 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20140527 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20140527 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20140527 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20140527 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20140527 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20140525 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20140525 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20140525 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20140525 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20140525 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20140525 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20140525 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20140416 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20140416 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20140416 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20140416 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20140416 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20140416 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20140416 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20140409 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20140409 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20140409 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20140409 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20140409 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20140409 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20140409 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20140228 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20140228 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20140228 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20140228 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20140228 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20140228 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20140228 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20140221 8.17
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20140221 8.17
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20140221 8.17
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20140221 8.17
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20140221 8.17
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20140221 8.17
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20140221 8.17
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20140113 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20140113 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20140113 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20140113 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20140113 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20140113 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20140113 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20140111 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20140111 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20140111 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20140111 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20140111 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20140111 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20140111 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20131230 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20131230 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20131230 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20131230 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20131230 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20131230 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20131230 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20131228 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20131228 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20131228 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20131228 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20131228 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20131228 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20131228 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20130424 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20130424 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20130424 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20130424 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20130424 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20130424 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20130424 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20130423 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20130423 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20130423 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20130423 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20130423 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20130423 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20130423 5.57
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20130419 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20130419 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20130419 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20130419 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20130419 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20130419 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20130419 5.54
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20130107 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20130107 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20130107 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20130107 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20130107 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20130107 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20130107 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20130106 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20130106 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20130106 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20130106 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20130106 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20130106 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20130106 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20121115 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20121115 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20121115 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20121115 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20121115 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20121115 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20121115 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20121111 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20121111 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20121111 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20121111 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20121111 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20121111 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20121111 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20121022 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20121022 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20121022 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20121022 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20121022 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20121022 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20121022 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20120924 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20120924 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20120924 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20120924 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20120924 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20120924 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20120924 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20120923 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20120923 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20120923 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20120923 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20120923 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20120923 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20120923 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20120820 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20120820 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20120820 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20120820 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20120820 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20120820 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20120820 5.49
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20120515 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20120515 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20120515 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20120515 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20120515 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20120515 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20120515 5.52
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20120301 6.43
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20120301 6.43
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20120301 6.43
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20120301 6.43
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20120301 6.43
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20120301 6.43
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20120301 6.43
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20120201 6.83
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20120201 6.83
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20120201 6.83
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20120201 6.83
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20120201 6.83
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20120201 6.83
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20120201 6.83
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 PA 20120101 6.83
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 PA 20120101 6.83
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 PA 20120101 6.83
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 PA 20120101 6.83
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 PA 20120101 6.83
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 PA 20120101 6.83
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 PA 20120101 6.83

In this case the resull should be:

5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2389 1.0 20171130 MD 20160321 5.6
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2323 9.0 20171031 MD 20160321 5.6
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2422 9.0 20171231 MD 20160321 5.6
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2395 16.0 20171231 MD 20160321 5.6
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2321 18.0 20170831 MD 20160321 5.6
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2466 1106.0 20180131 MD 20160321 5.6
5751888 AUGMENTIN DUO 875 MG 125 MG COMP.RE 2505 2516.0 20180131 MD 20160321 5.6

i have try everything

select ciusmd, nmismd, LTESMH, QSFSMH, DTVSLT, TPRDPR, DTPDPR as DTPDPR, PBCDPR as prec_max
from swapfilio.gesmh join swapfilio.gesmd
on NIISMH = NIISMD
join swapfilio.GESLT
on ARTSLT = NIISMH
and LOTSLT = LTESMH
join swapfilio.gefpr b
on ARTDPR = ARTSLT
where (TPRDPR = 'PA' or TPRDPR = 'MD' or TPRDPR = 'LM' or TPRDPR = 'NC' or TPRDPR = 'DP')
and SRGSMH = ''
and ARMSMH = '998'
--and LTGSLT <> 'S'
and QSFSMH <> '0'
and ciusmd = '5751888'
group by ciusmd, nmismd, LTESMH, QSFSMH, DTVSLT, TPRDPR, DTPDPR, PBCDPR
order by TPRDPR, DTPDPR desc

and like this:

select ciusmd, nmismd, LTESMH, QSFSMH, DTVSLT, max(DTPDPR) as DTPDPR, PBCDPR as prec_max
from swapfilio.gesmh join swapfilio.gesmd
on NIISMH = NIISMD
join swapfilio.GESLT
on ARTSLT = NIISMH
and LOTSLT = LTESMH
join swapfilio.gefpr b
on ARTDPR = ARTSLT
where b.PBCDPR =
(select max(c.PBCDPR)
from swapfilio.gefpr c
where c.artdpr = b.artdpr
and (TPRDPR = 'PA' or TPRDPR = 'MD' or TPRDPR = 'LM' or TPRDPR = 'NC' or TPRDPR = 'DP'))
and (TPRDPR = 'PA' or TPRDPR = 'MD' or TPRDPR = 'LM' or TPRDPR = 'NC' or TPRDPR = 'DP')
and SRGSMH = ''
and ARMSMH = '998'
and ciusmd = '5751888'
--and LTGSLT <> 'S'
and QSFSMH <> '0'
group by ciusmd, nmismd, LTESMH, QSFSMH, DTVSLT, PBCDPR

with a subquery the result is incorrect:

CIUSMD NMISMD LTESMH QSFSMH DTVSLT TPRDPR DTPDPR PREC_MAX
5090865 ALZEN SR 200MG 60COMP LK426 1.0 20180131 PA 20160105 49.321

please help me
Re: select max value in date [message #1729900 is a reply to message #1729739] Wed, 20 April 2016 03:51 Go to previous message
Eclipse UserFriend
Try this or an equivalent :
Select max(yourfield), .....
....
Having by max(yourfiled) < CURDATE() ;
Previous Topic:Report running hardcoded query. Not substituting params
Next Topic:BIRT REPORT
Goto Forum:
  


Current Time: Sat Nov 08 15:17:55 EST 2025

Powered by FUDForum. Page generated in 0.02962 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly