How to get the last transaction base on per month & year

[bsbernabe]

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

[lironbaram]

hi 

the easiest way will be to run 

load distinct in the script 

this will remove duplicates across the table  

[jonathandienst]

Which rows/values in your sample are duplicates?

[bsbernabe]

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.