Let's way the output of Query 1, without the rownumber column, would be
like this:
1.2.3.4
100.200.100.200
4.6.8.10
100.200.100.202
4.6.9.255
Using the ORDER BY and the @rownumber variable, we get an output that is
like this:
11.2.3.4
24.6.8.10
34.6.9.255
4100.200.100.200
510
what does your rownumber logic actually do? odds are that's probably whats
slowing you down
On Tue, Aug 13, 2019 at 7:46 PM Huji Lee wrote:
> Certainly doable! But I didn't ask this here because of not having a way
> to achieve my goal; I asked it because I am perplexed as to why the query
> nev
Certainly doable! But I didn't ask this here because of not having a way to
achieve my goal; I asked it because I am perplexed as to why the query
never finishes, despite its relatively simple structure and row number of
rows returned.
On Tue, Aug 13, 2019 at 7:43 PM Platonides wrote:
> Why not
Why not simply do the comparison client-side?
___
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud
