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.
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;
The Report
You are viewing a single comment's thread. Return to all 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 ..