How to select random rows from a table in SQL?

Question 1

How to select random rows from a table?

Question 2

Using a SAMPLE clause we can select random rows.

For Example,

SELECT * FROM table_name SAMPLE(10);

sharadyadav1986 · Answer 1 · 2020-07-10T11:09:10+0000

Using a SAMPLE clause we can select random rows.

For Example,

SELECT * FROM table_name SAMPLE(10);

Please log in or register to answer this question.