Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have table:
ROW ID
1 5
2 6
3 5
3 6
4 5
4 6
4 6
4 6
5 5
5 6
5 8
I need count the number of ID.
The final table should be:
ROW ID
1 1 - >(5)
2 1 - >(6)
3 2 - >(5,6)
4 2 - >(5,6)
5 3 - >(5,6,8)
Could you help me, how can I do it in script ?
Thank you.
Load
Count(distinct(ID) as ID,
Row
Resident Table
Group by Row;