The Report

  • + 0 comments

    What is the use of Decode function ?

    select (case when grade >=8 then name else null end) name, grade, marks from (select s.name, g.grade, s.marks from students s join grades g on s.marks between g.min_Mark and g.Max_Mark) order by grade desc, name;

    without it query working fine ..