--作业4、查询姓名最后一个字不是“超”字或“华”字的学生信息
-----------------------------------------------------------------
--作业5、查询学号最后一位是0-4的学生的信息
-----------------------------------------------------------------
--作业6、查询不姓“张”且名字的第三个字符不是“菲”字和“燕”字的学生信息

10

9

select name from table where name not in(
select name from table where name like '%超' or name like '%华'
)
比较笨 只想到这个

5.select * from Student where Sno like '%0' or Sno like '%1' or Sno like '%2' or Sno like '%3' or Sno like '%4'
6.select * from Student where Sname not like '张%' and Sname not like '__菲%' and Sname not like '__燕%'

5.
字段是int和nvarchar是不同处理
SELECT * FROM dbo.table WHERE RIGHT(appUserId,1) IN (1,2,3,4)
SELECT * FROM dbo.table WHERE RIGHT(account,1) IN ('1','2','3','4')

6
SELECT * FROM dbo.table WHERE LEFT(name,1) != '张' AND SUBSTRING(name,2,1) NOT IN ('燕','菲');
不知道要不要判断长度是否是3