You are viewing a single comment's thread. Return to all comments →
Awesome.It worked for me too in oracle.
when grade < 8
when grade >=8
end as name,grade,marks
where marks between min_mark and max_mark
order by grade desc,name;