so I have a table structure as follows:
Employee Task YYYYMM Hours
1 1 201903 3
1 2 201903 5
1 2 201905 8
2 2 201904 5
2 2 201905 6
I need the results to be Max YYYYMM for each Employee/task as follows
RESULT:
Employee Task YYYYMM Hours
1 1 201903 3
1 2 201905 8
2 2 201905 6
I don't know if I am just having a brain cramp or what but I cant figure out the sql to make it happen. any help is GREATLY appreciated
sorry about the data spacing. Not how I typed it... data should align with headers.