asked
How to combine two rows of same table, with out any common data
Need a single query to combine two rows of same table Actual Table Code-------Store---------Sect 1------------Null------------A 2------------abc------------Null 3------------XYZ-------------Null 4------------Null-------------B Desired O/P Code-------Store---------Sect 2-----------abc-------------A 3-----------XYZ-------------B
SELECT A.Code, A.Store, B.Sect FROM (SELECT Code , Store , Sect , ROW_NUMBER() OVER (PARTITION BY 1 ORDER BY Code)AS ROWNUM FROM TABLE_NAME WHERE Store IS NOT NULL)A INNER JOIN (SELECT Code , Store , Sect , ROW_NUMBER() OVER (PARTITION BY 1 ORDER BY Code)AS ROWNUM FROM TABLE_NAME WHERE Sect IS NOT NULL)A ON A.ROWNUM = B.ROWNUM
17 People are following this question.
