I have a view which produces three columns of data
Call_Number History Current_Group
1 1 5
1 2 8
1 3 6
2 1 6
2 2 6
3 1 8
3 2 9
I need to extract the call numer, the group and the history from the call's maximum row.
ie. Results should show
Call_Number History Current_Group
1 3 6
2 2 6
3 2 9
I have tried using serveral function without any luck.
Any help would be much appreciated.
Alasdair
Call_Number History Current_Group
1 1 5
1 2 8
1 3 6
2 1 6
2 2 6
3 1 8
3 2 9
I need to extract the call numer, the group and the history from the call's maximum row.
ie. Results should show
Call_Number History Current_Group
1 3 6
2 2 6
3 2 9
I have tried using serveral function without any luck.
Any help would be much appreciated.
Alasdair