/SQL/Sql how to get courses that i have made prerequisites

Sql how to get courses that i have made prerequisites

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);

Source: stackoverflow.com

Similar codes

4 votes202 views1 answer
Id increment ms sql server
SQL
0 vote272 views1 answer
How to find sql server name
SQL
0 vote208 views1 answer
Sql on-premises
SQL
5 votes203 views2 answers
Sql constraint check value in list
SQL
31 votes200 views4 answers
How to get duplicate records with multiple field in sql
SQL
1 vote184 views1 answer
Sql drop with dependencies
SQL
5 votes196 views1 answer
Mysql count lines
SQL
1 vote190 views1 answer
Drop table if exists oracle
SQL
2 votes188 views1 answer
Oracle virtual column
SQL
0 vote184 views4 answers
Mysql select bottom 10 rows
SQL