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


enter image description here

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


Popular posts from this blog

c# - ODP.NET Oracle.ManagedDataAccess causes ORA-12537 network session end of file -

matlab - Compression and Decompression of ECG Signal using HUFFMAN ALGORITHM -

utf 8 - split utf-8 string into bytes in python -