SELECT S# FROM SC GROUP BY S# WHERE COUNT（*）> 3 SELECT S# FROM SC GROUP BY S# HAVING COUNT（*）> 3 SELECT S# FROM SC ORDER BY S# WHERE COUNT（*）> 3 SELECT S# FROM SC ORDER BY S# HAVING COUNT（*）> 3
SELECT S#，SNAME FROM S WHERE SNAME=’李％’ SELECT S#，SNAME FROM S WHERE SNAME LIKE’李％’ SELECT S#，SNAME FROM S WHERE SNAME=’％李％’ SELECT S#，SNAME FROM S WHERE SNAME LIKE’％李％’
湘公网安备 43130202000226号