Breaking News: Grepper is joining You.com. Read the official announcement!

sql how to get courses that i have made prerequisites

Creepy Civet answered on March 21, 2021 Popularity 1/10 Helpfulness 1/10

answer sql how to get courses that i have made prerequisites

sql how to get courses that i have made prerequisites

Comment

SET @courses_completed = '2';
SELECT c.course_id
FROM course c
LEFT JOIN course_prerequisites p ON p.course_id = c.course_id
WHERE NOT FIND_IN_SET(c.course_id, @courses_completed)
GROUP BY c.course_id
HAVING SUM(COALESCE(FIND_IN_SET(p.prerequisite_course_id, @courses_completed), 0) > 0) = COUNT(p.prerequisite_course_id);

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: get prerequisites sql

Link to this answer
Share Copy Link