Multiple rows with null values - i want one row with not null
<p>My query result below:</p>

<pre><code>ID            desc             Year   pid
0006845503    tes1             null   null
0006845503    null             2017   null      
0006845503    null             null    90   
0006845503    null             null    null
</code></pre>

<p>I want to show these results:</p>

<pre><code>ID              desc               year    pid
0006845503      TEST1              2017    90
</code></pre>