The differences are
rank() gives two equal firsts a rank of 1, and the next rank given is 3 (mathematician's rank).
dense_rank() does likewise except that the next rank given is 2 (sportsperson's rank).
row_number() gives every row a different rank, even if the values being sorted on are equal.
Anti-nuisance lawsuit warning: The purpose of these notes is to remind me, Zoegond, of stuff or to help me work stuff out. They may contain mistakes.
Quick
- ($a, $b....) = unpack("A2A7...", $packed)
- push( array, list )
