demo07.sql

来自「Expert Oracle Database Architecture 9i a」· SQL 代码 · 共 8 行

select nt, min(id), max(id), count(*)
  from (
select id, ntile(10) over (order by id) nt
  from big_table
       )
 group by nt;