Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE table_name ( value ) AS
SELECT FLOOR(DBMS_RANDOM.VALUE(1, 1000001)) FROM DUAL CONNECT BY LEVEL <= 1000;
1000 rows affected

WITH indexed_values (value, rn) AS (
  SELECT value,
         ROW_NUMBER() OVER (ORDER BY value DESC) - 1
  FROM   table_name
),
assign_bins (value, rn, bin) AS (
  SELECT value,
         rn,
         CASE WHEN MOD(rn, 2 * 5) >= 5
         THEN 5 - MOD(rn, 5) - 1
         ELSE MOD(rn, 5)
         END
  FROM   indexed_values
)
SELECT bin,
       COUNT(*) AS num_values,
       SUM(value) AS bin_size
FROM   assign_bins
GROUP BY bin

BIN
NUM_VALUES
BIN_SIZE

0
200
98268203

1
200
98275540

2
200
98278562

3
200
98311509

4
200
98295824

WITH indexed_values (value, rn) AS (
  SELECT value,
         ROW_NUMBER() OVER (ORDER BY value DESC) - 1
  FROM   table_name
),
assign_bins (value, rn, bin) AS (
  SELECT value,
         rn,
         CASE WHEN MOD(rn, 2 * 5) >= 5
         THEN 5 - MOD(rn, 5) - 1
         ELSE MOD(rn, 5)
         END
  FROM   indexed_values
)
SELECT value
FROM   assign_bins
WHERE  bin = 0

VALUE

996730

986981

984887

975987

971617

959655

959083

950779

950316

941064

940065

935708

934779

926757

925081

915472

915433

910268

909124

903756

902829

893671

891419

881583

876010

863794

859048

851316

850592

839324

835832

828319

827841

817625

817307

807326

803041

795015

792329

787752

787421

782777

782338

773388

773157

770017

768498

757568

757213

746030

745836

740958

738260

727514

727418

715629

715553

705694

703648

693029

692763

679201

678223

666044

665557

655046

653338

644669

643473

632499

629638

625616

624447

616992

616596

604495

602745

594176

593540

579650

576748

566372

565373

555500

555316

547739

547077

539068

538762

530180

530016

517142

515952

502126

501868

496339

495189

491691

490333

482482

481231

475335

473807

465552

464583

453208

452752

447951

447383

443588

443088

436164

435724

427551

426311

415740

414344

398482

397472

390703

390627

384222

384127

375338

374095

366327

365927

357969

357954

345929

345443

331310

331107

318980

318869

310396

310186

299852

298220

285270

284843

274821

274708

268125

267236

262124

261749

250947

246694

241037

240900

231580

230197

225855

224820

216838

215798

204792

203824

195904

195614

184247

183102

174369

174213

170290

169074

157595

155524

149565

148620

137503

137269

124860

124452

118846

116313

109218

108137

98367

98075

88482

88087

80119

77678

64022

62514

54742

54482

48956

48584

40102

39964

34772

34763

25628

24207

14122

13055

1320
BIN	NUM_VALUES	BIN_SIZE
0	200	98268203
1	200	98275540
2	200	98278562
3	200	98311509
4	200	98295824