title: SQL query for this case?
body: <p>There is a Employee table having employee_id and employee_name<br><br>
  I want to insert "james" to this table.<br>
  If Employee table already has one "james" record i want his employee_id to be returned<br>
  if the table has more than one "james" records (duplicates) do nothing and skip <br>
  if there is no "james", i want to insert "james" and the new employee_id to be returned</p>
  
  <p>Guys how do i write a query for this.</p>
  
  <p>UPDATE: A answer for another of my <a href="https://stackoverflow.com/questions/4242749/looping-in-trigger">question </a> solved the issue. Thanks all for your guidance,</p>