Hi! Does anyone have snippet on how to rank grade average? the grades will be coming from a table (using sql2005 express)
thanks in advance!
Printable View
Hi! Does anyone have snippet on how to rank grade average? the grades will be coming from a table (using sql2005 express)
thanks in advance!
It's a simple Select Case statement. Test for the highest cut-off first and award an A, then the next highest cut-off and award a B, etc.