We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Basic Join
  4. The Report
  5. Discussions

The Report

  • salah_atabani
     + 10 comments

    I guess a more accurate one would be (I'm using Oracle):

    select (case when grade <8 THEN NULL ELSE name END) name, grade, marks
from
(select name, grade, marks
from students, grades
where marks between min_Mark and Max_Mark)
order by grade desc, name, decode(name,NULL,marks);

    in this case, if two students have the same grade and name and their name is not null they won't be ordered by their marks.