Could you explain how rows 1-4 are related? They are different ids in your example. Also, explain what you are trying to achieve and post DDL as it will make helping you easier.