title: Creating view when view columns are referring to a single column of a table with different where conditions
body: <p>I need to create a view: <strong>employee_view</strong></p>
  
  <pre><code>CREATE VIEW employee_view (Name_of_employee, Name_of_PL, Name_of_manager)
  AS 
  (
  Need help here!
  )
  
  Raj is an employe
  Vijay is a PL
  Kumar is a manager
  </code></pre>
  
  <p>The data for the view columns are coming from a single column of a table but with different where conditions. I need to create a view. Please help, table is mentioned below.</p>
  
  <p>table name: <strong>employee</strong></p>
  
  <pre><code>compid secid rowid fieldname
  22      1    6     Raj
  22      2    7     Vijay
  22      3    8     Kumar
  </code></pre>