[Solved] sql query how to get who knows morethan two lanuguage

by

[ad_1]

I hope this will help you.

SELECT * FROM (SELECT ID,NAME,GENRE,COUNT(LAN1)+COUNT(LAN2)+COUNT(LAN3) AS 
KNOWN_LANG FROM YOUR_TABLE GROUP BY NAME) WHERE KNOWN_LANG >=2

[ad_2]

solved sql query how to get who knows morethan two lanuguage