title: Select statement with multiple rows from condition on values in single column
body: <p>I have the table below.Using salary as condition I want to get multiple rows. 
  Below is current table call it employee.</p>
  
  <pre><code>    empid     name         salary
  -----------------------------------
  1   A1        alex        20000
  2   B2        ben         4500
  3   C1        carl        14000
  </code></pre>
  
  <p>compare the salary to certain fixed values, and every time the salary is larger than the fixed value, show a record in output.My attempt condition case is close to this:</p>
  
  <pre><code>   incometype= case When salary&lt;6000 then 101 When salary Between 6000 And 18000 Then
     102 Else 103 End
  </code></pre>
  
  <p>Desired ouput would be:</p>
  
  <pre><code>     empid     name   salary  incometype
  ------------------------------------------
  1   A1        alex    20000    101
  2   A1        alex    20000    102
  3   A!        alex    20000    103
  4   B2        ben     4500     101
  5   C1        carl    14000    101
  6   C1        carl    14000    102
  </code></pre>
  
  <p>I have tried using union but union will give me 3 rows for each record even when value meets 1st condition.</p>