You are viewing a single comment's thread. Return to all comments →
the sorting of this question is very confusing...
select Case when s.marks<=69 then NULL else s.name end as Names, Case when s.marks <=9 then 1 when s.marks >=10 and s.marks<=19 then 2 when s.marks >=20 and s.marks<=29 then 3 when s.marks >=30 and s.marks<=39 then 4 when s.marks >=40 and s.marks<=49 then 5 when s.marks >=50 and s.marks<=59 then 6 when s.marks >=60 and s.marks<=69 then 7 when s.marks >=70 and s.marks<=79 then 8 when s.marks >=80 and s.marks<=89 then 9 else 10 end as grades, s.marks from students s order by grades desc,s.name, s.marks asc;
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 →
the sorting of this question is very confusing...