Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello There,
how to get or max month & year to get the last transaction of Data Field?
sample data:
Account | Data | Month | Year |
023 | abcd123 | Jan | 2012 |
456 | efgd456 | Jan | 2012 |
789 | asdf123 | Jan | 2012 |
128 | abue123 | Jan | 2012 |
789 | asdf123 | Jan | 2012 |
623 | abcd123 | Feb | 2012 |
456 | efgd496 | Feb | 2012 |
789 | asdf123 | Feb | 2012 |
121 | asdf123 | Feb | 2012 |
Best Regards,
Bing
hi
the easiest way will be to run
load distinct in the script
this will remove duplicates across the table
Which rows/values in your sample are duplicates?
Hello There,
Sorry wrong subject what i did, actually what I need is how to get the last transaction Of Data Field base on Month and Year.