You are viewing a single comment's thread. Return to all comments →
priyanshu281, if it is having trouble with NULL and order, try converting the null into a 0.
The orderby line becomes:
order by G.Grade DESC, ISNULL(name, 0), Marks
Seems like cookies are disabled on this browser, please enable them to open this website
The Report
You are viewing a single comment's thread. Return to all comments →
priyanshu281, if it is having trouble with NULL and order, try converting the null into a 0.
The orderby line becomes:
order by G.Grade DESC, ISNULL(name, 0), Marks