title: I want to update the salary for the employees whose joined last 6 years in sql
body: <p>I tried this query, but I'm stuck in the <code>where</code> condition. Can anybody help me how to update the salary for the whose joined last 6 years?</p>
  
  <p>Query:</p>
  
  <pre><code>update emp
  set sal=sal+3000
  where doj=(select doj from emp where doj)
  </code></pre>