[ad_1]
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
[ad_2]
solved Mysql query to find out which id is having both french and german
[ad_1]
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
[ad_2]
solved Mysql query to find out which id is having both french and german