title: How to select random 100 records in HP Vertica?
body: <p>What function is used to select top 100 random records of a table in Vertica?</p>
  
  <p>In Sybase we use something like</p>
  
  <pre><code>Select top 100 * from table_name a order by rand(rowid(a))
  </code></pre>