select c_no from score group by c_no having count (*) >5
select cno from score where cno=? and degree >any()
SELECT * FROM person LEFT JOIN card on person.cardId = card.id
UNION
SELECT * FROM person RIGHT JOIN card on person.cardId = card.id;
原文：https://www.cnblogs.com/elric-cs/p/11712898.html