noon interview question
do you know window function and what is difference between dense rank and rank
Interview Answer
Anonymous
19 Jun 2024
window function helps to group by additional condition it make a window for each criteria and rank skips the next rank in case of duplicates while dense rank doesn't skip next rank in case of duplicate ( with example)