Oracleランキング抽出
OracleDBの場合ROW_NUMが用意されているので簡単♪
SELECT a.row_num, a.record_count
FROM hogetable a
WHERE TYPE = 1
ORDER BY a.record_count DESC
SELECT a.row_num, a.record_count
FROM hogetable a
WHERE TYPE = 1
ORDER BY a.record_count DESC
0 Comments:
Post a Comment
<< Home