Pergunta de entrevista da empresa noon

do you know window function and what is difference between dense rank and rank

Resposta da entrevista

Sigiloso

19 de jun. de 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)