title: How get the Id of inserted row in SQL
body: <p>My database table has ID column which is an auto incremental integer. While inserting data to the table its increment automatically I need to get the value of ID when a record is inserted.</p>
  
  <p>Eg: table employee = |ID| NAME | ADDRESS|</p>
  
  <p>the query is :</p>
  
  <blockquote>
    <p><code>insert into employee(NAME, ADDRESS) values("azzi", "test adress")</code></p>
  </blockquote>
  
  <p>there is a possible that we can change this query to return the ID soon after record inserted, some one help me to do that.</p>