I have a table X
ID A B -------------- 1 abc 27 1 - 28 2 - 33 3 xyz 41 3 - 07
I need output as
ID A B -------------- 1 abc 27 2 - 33 3 xyz 41
I tried doing
max(A) OVER (PARTITION BY ID) as the_value
but it did not work. I can still see all the rows in the output table.
I was wondering if somebody has come across a similar situation and has a solution to this ?
