SQL 练习8

  • 查询「李」姓老师的数量

SELECT Tname,COUNT(Tname)数量 from Teacher GROUP BY tname HAVING Tname LIKE '李%'

image

posted @ 2021-08-18 17:32  弩哥++  阅读(38)  评论(0)    收藏  举报