sql - removing null value from the table - oracle -

sql - removing null value from the table - oracle -

i have oracle table

header1 | header2 | header 3| header 4 --------+---------+----------+--------- abcd | 1 | null | null abcd | null | 3 | null abcd | null | null | 2

is there query get

header1 | header2 | header 3| header 4 --------+---------+----------+--------- abcd | 1 | 3 | 2

thanks in advance

try this

select header1,max(header2),max(header3),max(header4) table1 grouping header1

output be

header1 | header2 | header 3| header 4 --------+---------+---------+--------- abcd | 1 | 3 | 2

sql oracle select union