tableid number name score1 102
张三992104
李四
33(1)select 学号,姓名 from table where name like '李%' and length(姓名)=4(2)select count(*) from table where score>avg(score)...
上面的哥们写的不错,我再写另外的一种方式tableid number name score1 102
张三992104
李四
33(1)select 学号,姓名 from table where name like '张_'//“_”匹配1位(2)select count(1) from tabl...
(1)Select No,Name from student where substring(name,1,1)='张' and len(name)=2(2)select * from Studentscore where score>((select sum(score) from Studentscore)/(select Count(*) ...