首页 > 其他 > 详细

151028

时间:2015-10-28 23:00:22      阅读:349      评论:0      收藏:0      [点我收藏+]
select sname,ssex,class from t_hq_student;

select distinct depart from t_hq_teacher;

select * from t_hq_student;

select * from t_hq_score where degree between 60 and 80;

select * from t_hq_score where degree in (85,86,88);

select * from t_hq_student where class like95031 or ssex like ;

select * from t_hq_student order by class desc;

select * from t_hq_score order by cno;

select * from t_hq_score order by degree desc;

select class, count(1) as 人数 from t_hq_student where class =95031 group by class;

select * from t_hq_score where  degree >= all(select degree from t_hq_score);

select cno,avg(degree) as 平均成绩 from t_hq_score group by cno;

select sno from t_hq_score where degree > 70 and degree < 90;

 

151028

原文:http://www.cnblogs.com/zhuxiaolin/p/4918856.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!