mysql数据
1、select chinese,maths,english from student where class=1832；2、select chinese,maths,english from student where class=1833 and chinese>80 and chinese<90；3、select*from student where name limit 4,6；4、select number,name from student where english=98 or maths=77;5、 select chinese,maths,english from student where class=1832 order by chinese desc;6、 select name from student where class<1834 and chinese<80 and maths<80;7、select name,class from student where chinese is null;8、select name from student where chinese<60;9、select*from student group by class having avg(maths);10、select*from student group by class having sum(chinese);
页:
[1]