Your answer to the last FAQ is inaccurate. You don't HAVE to use PARTITION BY with the DENSE_RANK() function. If you don't use it (as in your first example) then the ranking is over the entire table.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply