[DATABASE/SQLITE] WITH문 사용하기

■ WITH문을 사용하는 방법을 보여준다.

▶ 예제 코드 (SQL)


WITH StudentSummary AS
(
    SELECT COUNT(*) AS TotalStudentCount FROM Student
)
SELECT
    SchoolID                                                        AS SchoolID,
    COUNT(*)                                                        AS StudentCount,
    COUNT(*) * 1.0 / (SELECT TotalStudentCount FROM StudentSummary) AS StudentRatio
FROM Student
GROUP BY SchoolID;

WITH StudentSummary AS

(

SELECT COUNT(*) AS TotalStudentCount FROM Student

)

SELECT

SchoolID AS SchoolID,

COUNT(*) AS StudentCount,

COUNT(*) * 1.0 / (SELECT TotalStudentCount FROM StudentSummary) AS StudentRatio

FROM Student

GROUP BY SchoolID;