Use SQL statements to randomly retrieve some data from a database table

When we used to randomly retrieve data from a table, we first read the data,

ThenProgramWe will randomly extract part of the data. Today we will tell you how to use SQL statements to randomly obtain part of the data.

SQL Server:

-- Obtain 10 data records at random
Select   Top   10   *   From Table Name Order   By   Newid ()

ORACLE:

-- Obtain 10 data records at random
Select   *   From ( Select   *   From Table Name Order   By Sys_guid ()) Where Rownum <=   10 ;
-- Method 2
Select   *   From ( Select   *   From Table Name Order   By Dbms_random.random ()) Where Ronum <=   10 ;