I have a table which I have created using group by grouping sets. It is done on 7 columns and at various levels.
Now at each level, i need to rank the lower hierarchical level using rank over function.
Can anyone help me with the syntax of the code?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.