Oracle随机获取记录 

1 SELECT A.* FROM TableA A CROSS JOIN (SELECT TRUNC(DBMS_RANDOM.VALUE(0,  999999999999999999999)) RANDOMNUM FROM DUAL) B ORDER BY B.RANDOMNUM

 

posted @ 2014-05-22 10:09  哈哈好玩  阅读(348)  评论(0)    收藏  举报