MySQL里面 1.如何查询莫一年莫个月份的学生学号和分数

1.

SELECT studentNo 学号,studentResult 分数

FROM result

WHERE examDate='2016-02-17'

ORDER BY studentResult DESC

LIMIT 5

2.

SELECT studentName 姓名,YEAR(NOW())-YEAR(bornDate) 年龄,bornDate 出生日期,phone 手机号码

From student

WHERE sex='女'

ORDER BY bornDate ASC

LIMIT 1,6

3.

SELECT YEAR(bornDate) 年份,COUNT(YEAR(bornDate)) 人数

FROM student

GROUP BY YEAR(bornDate)

HAVING COUNT(YEAR(bornDate))>=2

4.

SELECT MAX(studentResult) 最大值,MIN(studentResult) 最小值,AVG(studentResult) 平均值

FROM result

WHERE examDate='2016-02-17'

select top 3 sno from student order by sno ASC

order by age ASC 的意思是根据学号升序排列， 也就是说最前面的是学号最小的。 取前三个

这是一个嵌套查询的例子，先查出刘月的班级，然后通过in查询同班级的学生信息。如：select 学号,班级,姓名 from 学生表 where 班级 in(select 班级 from 学生表 where 姓名='刘月')

---