advanced code snippet search

Posted By

geekzspot on 12/08/10


Tagged

sql Oracle


Versions (?)

Random Row(s)

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. SELECT * FROM
  2. (
  3. SELECT myColoumn FROM myTable -- Your SQL here!
  4. ORDER BY dbms_random.value
  5. )
  6. WHERE rownum <= 5 -- Number of rows you want returned here.

Report this snippet  

You need to login to post a comment.