title: PostgreSQL : How to select values with only two digits after decimal point in a table?
body: <p>I have table called <code>nums</code>.</p>
  
  <pre><code>CREATE TABLE nums (num numeric);
  INSERT INTO  nums SELECT * FROM (VALUES(10.11),(11.122),(12.22),(13.555)) t;
  </code></pre>
  
  <p>It have following rows</p>
  
  <pre><code>select * from nums
  
  num
  --------
  10.11
  11.122
  12.22
  13.555
  </code></pre>
  
  <p>So my question is <em>how to get the values with only two digits after decimal point(<code>.</code>)?</em></p>
  
  <hr>
  
  <p>Expected Output :- </p>
  
  <pre><code>    num
      --------
      10.11
      12.22
  </code></pre>