title: SQL Group By And Display With Different Values
body: <p>I want to create group query where Table values are like this below:</p>
  
  <pre><code>EMP_ID  ProjectID
  815     1
  985     1
  815     3
  985     4
  815     4
  </code></pre>
  
  <p>And i want output like this</p>
  
  <pre><code>EMP_ID ProjectID1 ProjectID2 ProjectID3
  815    1          3          4
  985    1          4          0
  </code></pre>
  
  <p>can anyone know how can i achieve this thing in SQL query.</p>
  
  <p>Thank in advance.</p>