Guest User

Untitled

a guest
Jul 19th, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. #StandardSQL
  2. SELECT
  3. PERCENTILE_CONT(age, 0) OVER() AS min,
  4. PERCENTILE_CONT(age, 0.05) OVER() AS percentile5,
  5. PERCENTILE_CONT(age, 0.25) OVER() AS percentile25,
  6. PERCENTILE_CONT(age, 0.50) OVER() AS percentile50,
  7. PERCENTILE_CONT(age, 0.75) OVER() AS percentile75,
  8. PERCENTILE_CONT(age, 0.95) OVER() AS percentile95,
  9. PERCENTILE_CONT(age, 1) OVER() AS max
  10. FROM `data`
  11.  
  12. The query could not be executed in the allotted memory.
  13. OVER() operator used too much memory..
  14.  
  15. select PERCENTILE_CONT(age, 0.05) OVER() AS percentile5
  16. from data
Add Comment
Please, Sign In to add comment