Hi,
My actual resultset is attached, I am only interested in taking the last row per month.
In each month i cycle and get the next last day...
Thanks
db1 20 1 2017 972587.82812500000 972587.82812500000 1.000000000000000000
db1 21 1 2017 972587.82812500000 972587.82812500000 1.000000000000000000
db1 22 1 2017 972587.82812500000 972587.82812500000 1.000000000000000000
db1 24 2 2017 1030774.12695312500 1030774.12695312500 1.000000000000000000
db1 26 2 2017 1030774.12695312500 1030774.12695312500 1.000000000000000000
db1 15 3 2017 1078846.17968750000 1078846.17968750000 1.000000000000000000
db1 16 3 2017 1078846.17968750000 1078846.17968750000 1.000000000000000000
db1 26 3 2017 1078846.17968750000 1078846.17968750000 1.000000000000000000
db1 10 4 2017 1128924.55371093750 1128924.55371093750 1.000000000000000000
db1 20 4 2017 1128924.55371093750 1128924.55371093750 1.000000000000000000
db1 30 4 2017 1128924.55371093750 1128924.55371093750 1.000000000000000000
db1 03 5 2017 1128924.55371093750 1128924.55371093750 1.000000000000000000
db1 28 5 2017 1180317.30468750000 1180317.30468750000 1.000000000000000000