My record set is like below(only sample):
I need to get the if "col 7" is both rows are null I need to get the one single row from the two record.
col1 col2 col3 col4 col 5 col 6 col7
1 28 2ES-03B 2ES ER 2ES 2003-10-23 00:00:00.000 NULL
1 28 2ES-03B 2ES ER 2ES 1994-01-01 00:00:00.000 NULL
how can I achieve this?