2
Reply

how to remove null values and move and fill first two rows

rahul mekala

rahul mekala

Sep 28 2015 8:18 AM
322

how to remove null values and move and fill first two rows of the same COMPOUND_NAME column?????please help me..

<pre lang="sql">

COMPOUND_NAME 500 300 100 30 10 0.1 0.3

7977797 73.15965 NULL 43.27641 61.80586 NULL 47.49404 NULL

7977797 84.85707 NULL 40.38514 34.39364 NULL 12.47919 NULL

7977797 NULL NULL NULL NULL NULL NULL NULL

7977797 NULL NULL NULL NULL 20.08656 NULL -66.87882

7977797 NULL 53.25329 NULL NULL NULL NULL NULL

7977797 NULL 48.55260 NULL NULL 18.91425 NULL 48.55655 NULL

</pre>


Answers (2)