title: How to get row count in groovy sql
body: <p>Am new to groovy. Want to know how to get the number of rows from  a given sql result returned form an sql query below. I have googled lot but didn't find the proper solution.</p>
  
  <p>Here is my sql query class code</p>
  
  <pre><code>def sql = Sql.newInstance(dataSource);
  
      try
      {
          data = sql.rows("select field_value,form_table_column_name from 
                 form_tbl where form_id=1");
          sql_one.close()
  
      } catch(Exception e) {
  
         System.out.println(e)      
      }
  </code></pre>