You are viewing a single comment's thread. Return to all comments →
I made some changes, I thint this is more clear. The only issue with this question is the order by. Thx for explaining decode.
select (case when grade <8 THEN NULL ELSE name END) name, grade, marks
where marks between min_Mark and Max_Mark
order by grade desc, name, decode(name,NULL,marks);