Mysql query to find out which id is having both french and german -
what query find out id having both languages french , german?
you can use statement:
select id st name in ('german','french') group id having count(*)=2
you should rename column id
in student_id