Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

View sinabahram's full-sized avatar

Sina Bahram sinabahram

View GitHub Profile
@sinabahram
sinabahram / gist:1f59668c849c78d138445c266f1032c0
Created April 4, 2017 17:41
SQL to Return Rows within 95th Percentile
SELECT CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(field_name ORDER BY field_name SEPARATOR ','),  ',', 95/100 * COUNT(*) + 1), ',', -1) AS DECIMAL) AS `95th Per` FROM table_name;