Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #StandardSQL
- SELECT
- PERCENTILE_CONT(age, 0) OVER() AS min,
- PERCENTILE_CONT(age, 0.05) OVER() AS percentile5,
- PERCENTILE_CONT(age, 0.25) OVER() AS percentile25,
- PERCENTILE_CONT(age, 0.50) OVER() AS percentile50,
- PERCENTILE_CONT(age, 0.75) OVER() AS percentile75,
- PERCENTILE_CONT(age, 0.95) OVER() AS percentile95,
- PERCENTILE_CONT(age, 1) OVER() AS max
- FROM `data`
- The query could not be executed in the allotted memory.
- OVER() operator used too much memory..
- select PERCENTILE_CONT(age, 0.05) OVER() AS percentile5
- from data
Add Comment
Please, Sign In to add comment