编程论坛
注册
登录
编程论坛
→
SQL Server论坛
sql 语句
a1150163054
发布于 2013-01-04 15:27， 409 次点击
SELECT StudentID,Name,Sex,Birthdate,Scores
FROM Student
WHERE Sex='女'
COMPUTE BY MAX(Scores)
1 回复
#2
幽醉
2013-01-04 15:28
我教你，语句是Select top 1 StudentID,Name,Sex, Birthdate,Scores from student where sex='女' order by scores desc
1
