Oracle database - How to select several random records from a table.
How to select several random records from a table.
Sometimes it is necessary to select several random records from a database.
This task can be achieved by using built-in function VALUE (), also using another built in function ROWNUM and ORDER BY clause.
Suppose you have a table SoftFernNews from which you want to select 10 random rows containing Titles and IDs every time when user visits your home page.
Solution:
select *
from (
select NewsID, NewsTitle
from SoftFernNews
order by dbms_random.value()
)
where rownum <= 10
More similar topics with SQL tips: Oracle database - How to select several random records from a table
Database DB2 - How to select several random records from a table
MySQL database - How to select several random records from a table
PostgreSQL - How to select several random records from a table
Microsoft SQL Server - How to select several random records from a table