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
(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 ..