摘要:
--切换数据库use MySchool --查询对应年级下的学生人数SELECT COUNT(1) AS '人数' FROM Student WHERE GradeId=1SELECT COUNT(1) AS '人数' FROM Student WHERE GradeId=2SELECT COUNT 阅读全文
摘要:
--模糊查询:查询学生表中姓'王'的学生记录 --'%':匹配0-n个任意字符 --'_'匹配单个字符 --'[]'匹配区间内的值:如[13]--'[^]'匹配区间内不包含的值SELECT * FROM Student WHERE StudentName LIKE '王_'SELECT * FROM 阅读全文