擅长:python、mysql、java
<p>使用NTILE很简单,但它是一个Postgres函数。你基本上就是这样做的:</p>
<pre><code>SELECT value_you_are_NTILING,
NTILE(4) OVER (ORDER BY value_you_are_NTILING DESC) AS tiles
FROM
(SELECT math_that_gives_you_the_value_you_are_NTILING_here AS value_you_are_NTILING FROM tablename);
</code></pre>
<p>下面是我在SQLFIDLE上为您制作的一个简单示例:<a href="http://sqlfiddle.com/#!15/7f05a/1" rel="nofollow noreferrer">http://sqlfiddle.com/#!15/7f05a/1</a></p>
<p>在MySQL中,您将使用RANK。。。以下是SQLFIDLE:<a href="http://www.sqlfiddle.com/#!2/d5587/1" rel="nofollow noreferrer">http://www.sqlfiddle.com/#!2/d5587/1</a>(来自下面链接的问题)</p>
<p>MySQL RANK()的使用来自这里回答的Stackoverflow:<a href="https://stackoverflow.com/questions/3333665/rank-function-in-mysql">Rank function in MySQL</a></p>
<p>寻找萨尔曼A.的答案</p>