[Solved] Mysql query to find out which id is having both french and german

by


You can use this statement:

SELECT id
FROM st 
where name in ('german','french')
Group by id
having Count(*)=2

You should rename the column id in student_id

solved Mysql query to find out which id is having both french and german