Archives of the TeradataForum

Message Posted: Thu, 06 Jul 2006 @ 12:55:31 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I may not understand the question, but check out the Functions and Operators manual under Ordered Analytical Functions / QUANTILE. It suggests this expression:

     (RANK() OVER (ORDER BY sort-columns) - 1) * 100 / COUNT(*) OVER()

	<Prev	Next>		<<First	<Prev	Next>	Last>>