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

  • tejasvi2023
     + 1 comment

    MS SQL SERVER by CTE

    WITH CTE AS
(
    SELECT S.Name, S.Marks, G.Grade
    FROM Students S
    JOIN
    Grades G
    ON S.Marks >= G.Min_mark AND S.Marks <= G.Max_mark
)
SELECT CASE 
            WHEN CTE.Grade >= 8
            THEN CTE.Name
            ELSE Null
        END,
        CTE.Grade,
        CTE.Marks
FROM CTE
ORDER BY CTE.Grade DESC, 
        CASE WHEN CTE.Grade >= 8
        THEN CTE.Name
        END ASC,
        CASE WHEN CTE.Grade <= 8
        THEN CTE.Marks
        END ASC