Infosys Interview Question

Question on window function in SQL