You are viewing a single comment's thread. Return to all comments →
This works in MySQL but not in Oracle, does anybody know why?
select if(grades.grade > 7, students.name, null), grades.grade, students.marks
from students, grades
where marks between min_mark and max_mark
order by grade desc, name;
it does not enforce ordering by makrs when there is a tie for grade < 8.