[Quote=引用 6 楼 sdhdy 的回复:]
SQL code
--排名
select a.u_id,a.u_loginname,px=(select count(1) from tb_permarks where u_id=b.u_id and u_marks>b.u_marks)+1 from tb_users a,tb_permarks b where a.u_id=b.u_id
[Quote=引用 7 楼 sdhdy 的回复:]
引用 6 楼 sdhdy 的回复:
SQL code--排名
select a.u_id,a.u_loginname,px=(select count(1) from tb_permarks where u_id=b.u_id and u_marks>b.u_marks)+1 from tb_users a,tb_permarks b where a.u_id=b.u_id
[Quote=引用 6 楼 sdhdy 的回复:]
SQL code--排名
select a.u_id,a.u_loginname,px=(select count(1) from tb_permarks where u_id=b.u_id and u_marks>b.u_marks)+1 from tb_users a,tb_permarks b where a.u_id=b.u_id
[/Quote]
在表u_id列上都加上索引,可以做成视图。
--排名
select a.u_id,a.u_loginname,px=(select count(1) from tb_permarks where u_id=b.u_id and u_marks>b.u_marks)+1 from tb_users a,tb_permarks b where a.u_id=b.u_id