1.查询语文成绩并进行排序
2.要在排序后输出语句上添加序号
sql语句:select u.* ,(@rownum :=@rownum+1) orders from user u,(select @rownum:=0 ) n where u.subjects='语文' order by u.score desc ;
1.查询语文成绩并进行排序
2.要在排序后输出语句上添加序号
sql语句:select u.* ,(@rownum :=@rownum+1) orders from user u,(select @rownum:=0 ) n where u.subjects='语文' order by u.score desc ;