We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
SELECT grade_level, MAX(CASE WHEN rn = 1 THEN cnt END) first_result, MAX(CASE WHEN rn = 2 THEN cnt END) second_result, MAX(CASE WHEN rn = 3 THEN cnt END) third_result, SUM(cnt) total_enrolled FROM (SELECT q.*, ROW_NUMBER() OVER(PARTITION BY grade_level ORDER BY home_room) rn FROM ( SELECT grade_level, home_room, COUNT(*) cnt FROM students WHERE enroll_status = 0 AND schoolid IN (3) GROUP BY home_room, grade_level) q) GROUP BY grade_level ORDER BY grade_level;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Oracle 11gR2 Middleware: multiple domains with individual admin servers?||4||44|
|Oracle perfomance tuneing.||3||47|
|Does INTERSECT return opposite from FULL OUTER JOIN?||4||41|
|Error creating summetric key on SQL 2012 (Amazon)||7||46|
Join the community of 500,000 technology professionals and ask your questions.