tyson記事本

Google & man(Unix) are your best friends!

Skip to: Content | Sidebar | Footer

亂數取記錄

2 February, 2007 (13:45) | Oracle, SQL | By: tyson

selecting random record.

select employees,name from
(select employees,name from usertable order by dbms_random.value)
where rownum < = 5

update: ref: http://forums.oracle.com/

« 辦公大樓整修
推廌軟體: Automate, SecondCopy, AlwaysSync, LaunchPad »

Write a comment





For spam filtering purposes, please copy the number 4736 to the field below: