MySQL語句如何實現從數據庫表中查詢隨機數據的記錄
1. Oracle,隨機查詢20條
select * from
(
select * from 表名
order by dbms_random.value
)
where rownum <= 20;
2.MS SQL Server，隨機查詢20條
select top 20 * from 表名order by newid()
3.My SQL:，隨機查詢20條
select * from 表名 order by rand() limit 20
SELECT * FROM phpcms_video where catid=17 order by rand()
獲取到的隨機結果如下圖所示：
1. Oracle,隨機查詢20條
select * from
(
select * from 表名
order by dbms_random.value
)
where rownum <= 20;
2.MS SQL Server，隨機查詢20條
select top 20 * from 表名order by newid()
3.My SQL:，隨機查詢20條
select * from 表名 order by rand() limit 20
SELECT * FROM phpcms_video where catid=17 order by rand()
獲取到的隨機結果如下圖所示：
鄂公網安備 42090202000212號