select SNAME,SSEX,CLASS from student;
select distinct DEPART from teacher;
select * from student;
select * from score where degree between 60 and 80;
select * from score where degree=85 or degree=86 or degree=88;
select * from student where class='95031' and ssex='女';
select * from student order by class desc;
select * from score order by degree desc , cno;
select count(*) as '人数' from student where class='95031';
select * from score order by degree desc limit 1;
select avg(degree) from score where CNO='3-105';
select cno,avg(degree) from score where cno like '3%' group by cno having count(sno)>5;
select sno from score group by sno having min(degree)>70 and max(degree)<90;
更多查询语句请参考MySQL查询语句集合
本网页所有视频内容由 imoviebox边看边下-网页视频下载, iurlBox网页地址收藏管理器 下载并得到。
ImovieBox网页视频下载器 下载地址: ImovieBox网页视频下载器-最新版本下载
本文章由: imapbox邮箱云存储,邮箱网盘,ImageBox 图片批量下载器,网页图片批量下载专家,网页图片批量下载器,获取到文章图片,imoviebox网页视频批量下载器,下载视频内容,为您提供.
阅读和此文章类似的: 全球云计算
官方软件产品操作指南 (170)
