Posted By

jordantbro on 01/21/09


Tagged

Oracle


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

geekzspot


Selecting a Random Row From Oracle


 / Published in: SQL
 

  1. SELECT COLUMN FROM
  2. ( SELECT COLUMN FROM TABLE
  3. ORDER BY dbms_random.value )
  4. WHERE rownum = 1

Report this snippet  

You need to login to post a comment.