Hi ,
I have a req as follows:
My table structure is something like below:
TestID Distinction First Second
101 85% 60% 50%
102 50% 85% NULL
103 50% 60% 85%
I want my result as following:
TestID 50% 60% 85%
101 Second First Distinction
102 Distinction NULL First
103 Distinction First Second
Appreciate your help.