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.
The Report
You are viewing a single comment's thread. Return to all comments →
This works in MySQL but not in Oracle, does anybody know why?
it does not enforce ordering by makrs when there is a tie for grade < 8.