advanced code snippet search

Posted By

geekzspot on 01/04/13


Tagged


Versions (?)

Oracle Select a Random Row

 / Published in: SQL
 

Select (column(s) from a) random row

Expand | Embed | Plain Text 
  1. SELECT * FROM ( 
  2.     SELECT COLUMN FROM TABLE  --< Your Query Here!
  3. ORDER BY DBMS_RANDOM.VALUE) 
  4. WHERE ROWNUM = 1 
  5. ;

Report this snippet  

You need to login to post a comment.