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.
HERE is the easiest SQL SERVER Code I can think of:
SELECT
CASE WHEN G.Grade<8 THEN NULL ELSE S.Name END AS Name,
G.Grade,
S.Marks
FROM Students S INNER JOIN Grades G ON S.Marks BETWEEN G.Min_Mark and G.Max_Mark
ORDER BY G.Grade DESC,Name,Marks
The Report
You are viewing a single comment's thread. Return to all comments →
HERE is the easiest SQL SERVER Code I can think of:
SELECT CASE WHEN G.Grade<8 THEN NULL ELSE S.Name END AS Name, G.Grade, S.Marks FROM Students S INNER JOIN Grades G ON S.Marks BETWEEN G.Min_Mark and G.Max_Mark ORDER BY G.Grade DESC,Name,Marks