mysql 排名次问题

[militala2]

total created
234 2011-08-21 18:22:48
34 2011-08-21 19:20:54
1 2011-08-21 20:02:00
1 2011-08-21 20:00:26
1 2011-08-21 20:00:26
1 2011-08-21 19:44:02
1 2011-08-21 19:34:08


怎按total created 排名次

例如

total created rank
234 2011-08-21 18:22:48 1
34 2011-08-21 19:20:54 2
1 2011-08-21 20:00:26 3
1 2011-08-21 20:02:00 4
1 2011-08-21 19:44:02 5
1 2011-08-21 19:34:08 6

[chuanzhang5687]

建议去MYSQL问问

[geniuswjt]

--mssql
select total,created,rank=row_number() over (order by total desc,created)
from tb
--mysql的话传送门
mysql
go

[--小F--]

建议去MYSQL问问