100% of my use of RIGHT JOIN has been during technical assessments in interviews when I already started writing my query and realized I should have put the other table first. I wish I had kept track of my pass rate from those interviews lol.
I know I've fiddled around many times with RANK/DENSE RANK/ROW NUMBER but I don't remember if I ever actually used a rank function instead of row number. I always have to look up the difference between RANK and DENSE RANK though.
100% of my use of RIGHT JOIN has been during technical assessments in interviews when I already started writing my query and realized I should have put the other table first. I wish I had kept track of my pass rate from those interviews lol.
I know I've fiddled around many times with RANK/DENSE RANK/ROW NUMBER but I don't remember if I ever actually used a rank function instead of row number. I always have to look up the difference between RANK and DENSE RANK though.
yesss rank and dense rank ALWAYS show up in interviews but i rarely use them in the real world. I'd love to see the right join pass rate for you LOL