title: Why 'Select' is called as DML statement ?
body: <p>I see lot of debate of 'Select' being called as DML. Can some one explain me why its DML as its not manipulating any data on schema? As its puts locks on table should this be DML? </p>
  
  <p>*<em>In Wikipedia *</em> I can see  </p>
  
  <blockquote>
    <p>"The purely read-only SELECT query statement is classed with the
    'SQL-data' statements[2] and so is considered by the standard to be
    outside of DML. The SELECT ... INTO form is considered to be DML
    because it manipulates (i.e. modifies) data. In common practice
    though, this distinction is not made and SELECT is widely considered
    to be part of DML.[3]"</p>
  </blockquote>
  
  <p>But in SELECT * FROM INSERT select will just perform selection nothing other than this!! Please someone help me in understanding this concept.</p>
  
  <p>Thanks</p>