Varshini S
asked on
How to arrange the SQL output in order ?
I have the following table
Name Qualification
-------------------------- ---------- ---------
Steve IT|MBA|BA
John MS|IT|MBA|BA
Chris IT|BA
Mike MS|MBA
I need to order the output in the following way
Name Qualification
Steve BA|MBA|IT
John BA|MBA|IT|MS
Chris BA|IT
Mike MBA|MS
Qualification needs to be in this order > BA,MBA,IT and MS
How to achieve this in SQL query ?
Name Qualification
--------------------------
Steve IT|MBA|BA
John MS|IT|MBA|BA
Chris IT|BA
Mike MS|MBA
I need to order the output in the following way
Name Qualification
Steve BA|MBA|IT
John BA|MBA|IT|MS
Chris BA|IT
Mike MBA|MS
Qualification needs to be in this order > BA,MBA,IT and MS
How to achieve this in SQL query ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.