?从数据库表格中随机抽取行有什么用？因为有时候你会想要给用户展示一些随机的信息。下面介绍在几个流行的数据库中提取随机行的代码

?

MySQL中提取10个随机行

??? SELECT column FROM table? ORDER BY RAND()? LIMIT 10

?

?

Oracle中提取10个随机行

??? SELECT column FROM? ( SELECT column FROM table? ORDER BY dbms_random.value )? WHERE rownum <= 10

?

?

?PostgreSQL中提取10个随机行

??? SELECT column FROM table? ORDER BY RANDOM()? LIMIT 10

?

?

? Microsoft SQL Server中提取10个随机行

??? SELECT TOP 10 column FROM table? ORDER BY NEWID()