As shown, integrating multiple lines of the same id for a row, delete a null value, can you tell me how to achieve? Use the select or update will do

CodePudding user response:

Select id, Max (value), Max (value2), Max (value3), Max (value4), Max (value5) from the table name group by id