​A selection of topics on IT and its application to finance. 
​Send me your comments, questions ​or suggestions by clicking
h​ere


elmama
Split a table into roughly equal non-overlapping sections
/* Split a table into roughly equal non-overlapping sections */

select min(object_id) min. max(object_id) max, count(*) cnt, nt
from

(
    select object_id, ntile(8) over(order by object_id) nt from all_objects
)

​group by nt