How to select random 100 records in HP Vertica?

Question

What function is used to select top 100 random records of a table in Vertica?

In Sybase we use something like

Select top 100 * from table_name a order by rand(rowid(a))

Answer 1

It's pretty similar:

select * from table_name a order by RANDOM() LIMIT 100 

There's that curious thing called a manual; it's full of little gems like this.