Skip to content
Advertisement

Count amount of same value

I have a simple task which I to be honest have no idea how to accomplish. I have these values from SQL query:

I would like to display a bit modified table like this:

So, the idea is simple – I need to append a new column and set ‘Multiple’ and ‘Single’ value depending on if customer Id exists multiple times

Advertisement

Answer

Use window functions:

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement