title: sql to filter decimal and non decimal integer in sql server
body: <p>I have following table </p>
  
  <pre><code>marks
  45
  45.5
  56
  56
  56.6
  </code></pre>
  
  <p>I need to write a query to list the marks which are not in decimal value i.e </p>
  
  <pre><code>marks
  45
  56
  56
  </code></pre>
  
  <p>Is there any sql query to filter decimal and non decimal integer in sql server</p>