title: How to copy record from one table to the same table
body: <p>I have a insert select query in my stored procedure. In the query below, I inserted one record. What I want to do is to copy this record and insert to the same table but the salary will be negative. I am not sure what how to do it. Help will be appreciated </p>
  
  <p>Here is part of my code </p>
  
  <pre><code>Insert into employee_name, age, Sum(salary)
  Select employee_name, age, salary from employee
  group by employee_name
  </code></pre>
  
  <p>Record </p>
  
  <pre><code>   employee_name  age    salary
     John           39    $30,000
  </code></pre>
  
  <p>What I want </p>
  
  <pre><code>employee_name   age    salary
  John            39    $30,000
  John            39    $-30,000
  </code></pre>