/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

0 vote134 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote138 views1 answer
Oracle list datafiles
SQL
0 vote129 views1 answer
Oracle grant create job
SQL
1 vote130 views1 answer
Sql select all from one table and one column from another
SQL
0 vote142 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote135 views1 answer
Mysql_error replacement
SQL
0 vote140 views1 answer
Pl sql round
SQL
0 vote178 views1 answer
Insert into table with only identity column
SQL
0 vote170 views1 answer
Suhaib
SQL
1 vote151 views1 answer
Drop primary key oracle
SQL