Mysql – Get all distinct values from column1 in case of 2 similar rows, get the one with column2 not null
I have a large table as dataset. If there are 2 similar rows with same date and id then how do I get the row for which another column value is not null? SELECT *, row_number() over (partition by id…