'rank()'에 해당되는 글 1건
- 2010/10/21 :: MS SQL 2000에서 RANK 구현
Study/mssql
2010/10/21 13:11
select
(
select count(*) + 1
from tmp_rank b
where b.visits > a.visits
) as ranking
, pno
, visits
from
tmp_rank a
order by ranking
