SQL Partition field with value

Viewed 40

I'm new to partition, i can only do partition by round, avg, min, max.

I'd like to partition the field 'Identifier' in the below image.

If there is a same ID but the other one has no identifier while the other one has Identifier, I'd like to print the identifier value of the other ID to the ID with blank identifier.

I know it's possible but I can't seems to get it.

Send pls, pls. enter image description here

0 Answers
Related