0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

SELECT 
MAX(Reputation)
FROM
(
SELECT 
Reputation, NTILE(10) OVER(ORDER BY Reputation) AS Percentile
FROM Users 
WHERE Location COLLATE Latin1_general_CI_AI LIKE '%dallas, tx%' COLLATE Latin1_general_CI_AI
) a
GROUP BY Percentile;

fork query

edited may 13 13

created may 13 13 anonymous