Loading collection data...
Collections are a way for you to organize kata so that you can create your own training routines. Every collection you create is public and automatically sharable with other warriors. After you have added a few kata to a collection you and others can train on the kata contained within the collection.
Get started now by creating a new collection.
If this is a joke it's a really clever one
yes
what is the benefit of using rank() vs row_num() ?
I enjoyed the NULLIF inside COALESCE. Congrats!
relax bud
Maybe
From PostgreSQL 14 documentation, 7.2.5:
Currently, window functions always require presorted data, and so the query output will be ordered according to one or another of the window functions' PARTITION BY/ORDER BY clauses. It is not recommended to rely on this, however. Use an explicit top-level ORDER BY clause if you want to be sure the results are sorted in a particular way.
https://www.postgresql.org/docs/14/queries-table-expressions.html
This comment is hidden because it contains spoiler information about the solution
This comment is hidden because it contains spoiler information about the solution
No it won't. https://www.citusdata.com/blog/2016/10/12/count-performance/
This comment is hidden because it contains spoiler information about the solution
Yes.
Nope.
Took me some time to get to this after numerous timeouts...:-)
That is a great solution but I am having a bit of a difficulty understanding it. Would you mind elaborating a bit?
Loading more items...