Guest User

Untitled

a guest
Jan 16th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. SELECT * FROM (
  2. SELECT id, age, sex, height, weight, attendence_time,
  3. EXP1.rownum, MOD(INITIAL.rownum-1, CEIL(COUNT(*) OVER () /1000)) AS person_mod
  4. FROM (
  5. SELECT id, age, sex, height, weight, attendence_time,
  6. ROW_NUMBER() OVER(ORDER BY attendence_time) AS rownum
  7. FROM person p
  8. WHERE p.age = :age
  9. ) INITIAL
  10. ) MODROW WHERE MODROW.person_mod = 0 OR rownum = (
  11. SELECT COUNT(*)
  12. FROM person p
  13. WHERE p.age = :age
  14. )
Add Comment
Please, Sign In to add comment