<div id="readability-page-1" class="page"><div>
            <h2 id="%EB%AC%B8%EC%A0%9C">문제</h2><figure><a href="https://leetcode.com/problems/highest-grade-for-each-student/description/"><div><p>Loading...</p><p>Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.</p><p><img src="https://leetcode.com/favicon-192x192.png" alt=""><span>LeetCode</span></p></div><p><img src="https://leetcode.com/static/images/LeetCode_Sharing.png" alt=""></p></a></figure><h2 id="%EC%A0%95%EB%8B%B5">정답</h2><pre><code>WITH Ranks AS (
    SELECT *, RANK() OVER(
        PARTITION BY student_id
        ORDER BY grade DESC
    ) as 'rank'
    FROM Enrollments
)
# SELECT Enrollments.*
# FROM Enrollments, Ranks
SELECT student_id, MIN(course_id) as course_id, grade
FROM Ranks
WHERE Ranks.rank = 1
GROUP BY student_id</code></pre>
        </div></div>

일시불 프로그래밍

문제
정답
WITH Ranks AS (
    SELECT *, RANK() OVER(
        PARTITION BY student_id
        ORDER BY grade DESC
    ) as 'rank'
    FROM Enrollments
)
# SELECT Enrollments.*
# FROM Enrollments, Ranks
SELECT student_id, MIN(course_id) as course_id, grade
FROM Ranks
WHERE Ranks.rank = 1
GROUP BY student_id

Leetcode - 1112. Highest Grade For Each Student

댓글