--my solution: ( Benim çözümüm) SELECT a.col1, b.col2 --,lower_bound,upper_bound FROM tbl a INNER JOIN (SELECT col1 AS col2, (SUM(col1) OVER (ORDER BY col1 ASC))-col1+1 AS lower_bound, SUM(col1) OVER (ORDER BY col1 ASC) AS upper_bound FROM TBL ) b ON a.col1 BETWEEN b.lower_bound AND b.upper_bound ORDER BY 1; --solution of my friend... based on (N*(N+1))/2 formula. It is converted writeable version :) --(arkadasimin çözümü. (N*(N+1))/2 formulünden faydalandi. Fakat koda dökülebilir versiyonu bu halde oldu :) select col1,round(sqrt(col1*2)) from tbl;