MySQL Forums
Forum List  »  Chinese

动态排序问题
Posted by: David Wong
Date: June 20, 2008 11:33PM

hello,问个问题,希望有空解惑一下。
数据库的动态排序问题。
name math english total ranklist
jack 80.00 90.00 170.00 2
tom 95.00 90.00 185.00 1
jerry 50.00 40.00 90.00 3
注意ranklist是动态更新的一个排名列,请问在mysql中能实现啊。sqlserver似乎可以用rank()解决,但是mysql中没有这样的函数吧。。

Options: ReplyQuote


Subject
Views
Written By
Posted
动态排序问题
45581
June 20, 2008 11:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.