SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE tybcom ( STUDENT_ID INT, COURSE CHAR(25)); INSERT INTO tybcom VALUES (001, 'Maths'),(001, 'Eco'),(002, 'Maths'), (001, 'FC'),(002, 'FC'),(003, 'FC'); SELECT distinct (A.STUDENT_ID) AS ID_with_atleast_2_course FROM tybcom A,tybcom B WHERE A.STUDENT_ID=B.STUDENT_ID AND A.COURSE != B.COURSE;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear