How to select random rows from a table in SQL?

Question

How to select random rows from a table?

Answer 1

Using a SAMPLE clause we can select random rows.

For Example,

SELECT * FROM table_name SAMPLE(10);