vendredi 29 juillet 2016

MySQL Query students that studied for all the schools

Table consists of School_id and Student_name.

School_id   Student_Name
1           Raj
1           Tan
1           Brian
2           Raj
2           Brian
3           Raj
3           Tan

So the output should be Raj, as Raj has studied in all schools(1,2,3).

Aucun commentaire:

Enregistrer un commentaire