title: SQL : Round off to 1 decimal Point
body: <p>I am trying to round my value to one decimal, below is sample which I tried.</p>
  
  <pre><code>INPUT     DESIRED OUTPUT
  129.700   129.7
  129.769   129.8
  </code></pre>
  
  <p>I have tried</p>
  
  <pre><code>SELECT CAST(ROUND(('129.768'),0) AS DECIMAL(10,1))
  FROM Table1
  </code></pre>
  
  <p>is not giving correct value.</p>
  
  <p>Please help.</p>