close

Goge Layukan Kwafi a cikin MySQL- Goge layuka masu kwafi ta amfani da GAME DA bayanin JOIN

Share duk Layukan Kwafi banda Daya a cikin MySQL? [kwafi]

Teburin mai amfani yana da bayanai guda 5 tare da kwafin imel ɗin [email protected]

Bincike yana mayar da kwafin imel ɗin a cikin Teburin Masu amfani: 

SELECT *, COUNT(email) FROM users  
GROUP BY email   
HAVING  COUNT(email) > 1;

Share kwafin layuka ta amfani da GAME DA sanarwa 

DELETE table1 FROM users table1  
	INNER JOIN users table2   
	WHERE table1.id < table2.id AND table1.email = table2.email

Sakamako