Oracle randomly takes a value from a column

Select t.recd_id from (select recd_id, ROWNUM RN from RT_TICKETS_BIS_RECD) t where T.rn = (select round (dbms_random. VALUE (1, COUNT (1))) from RT_TICKETS_BIS_RECD);

1)

Select Round (dbms_random. VALUE (1, COUNT (1))) from RT_TICKETS_BIS_RECD

Dbms_random. VALUE (Low,high), gets a random number from the interval [Low,high], and the round () rounding function

The function of the above SQL implementation is to get the number of records for that table from the table RT_TICKETS_BIS_RECD, and then get a random integer in [1,count]

2)

Select recd_id, ROWNUM RN from RT_TICKETS_BIS_RECD) t where T.rn =

Use RowNum to get the article RN record in the result set.

Oracle randomly takes a value from a column