How to select 3 random records from the last 100 in postgres?

Question

PostgreSQL

How to select 3 random records from the last 100 in postgres?
Those. you need to take the last 100 records in the table and select randomly from the bottom 3

Answer 1

SELECT *
FROM
  (SELECT * you_table
   ORDER BY id DESC
   LIMIT 100) AS last_records
ORDER BY random()
LIMIT 3;