merging nearly- duplicate rows from different databases in the same table
I am sure , that many people before me faced a need to merge nearly- duplicate rows from several databases. However, I have not been able to find a simple yet general solution. I provided a data sample in Excel here: https://disk.yandex.ru/d/UtuENQ4LXHmOmQ It shows in yellow the 4 rows, that I have now, and one row in green, that I want to make. The new row should have some data only from one of the 4 database in some columns, and merged from all (or some) databases in other columns. I will delete the original rows after the merger. I spent all morning trying to figure out what functions to use. I have INSERT INTO, VALUES, WHERE , but smth else is missing. Could someone please direct me to a possible solution?
There is no intrinsic order to the rows in a Relational database table.
Given this, how do you intend to identify "Row 1" and "Row 2"?
If your data already exists in "Row 1" and "Row 2", why do you want to duplicate that data (into "Row 3")?
Duplication of data is generally a Bad Idea.
Show us the structure of your table(s) and enough sample data to better understand your scenario. That way, we might be able to offer you better advice. Right now, we're basically guessing.