The Report

  • + 1 comment

    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;