How to make and update ranking in database c#
<p>I have this query:</p>

<pre><code>Select [col], DENSE_RANK() Over(ORDER BY col DESC)as rank From Table
</code></pre>

<p>I have 2 column, x and y.
But i want to update data in column x with result of DENSE_RANK(). Honeslty, i don't know how can that's query work, but when i try, that's work.</p>

<p>But when i tried that's query in query builder, will appear a warning "The OVER SQL construct or statement is not supported." . So i need to make ranking of data in column x, then save the result of ranking into column y.</p>