Skip to content

Instantly share code, notes, and snippets.

@Khrol

Khrol/random_query.sql

Created October 7, 2013 18:07
Show Gist options
  • Save Khrol/6872365 to your computer and use it in GitHub Desktop.
Save Khrol/6872365 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
random_query.sql
select * from (
select order_id from orders where funny_order = 1
order by dbms_random.value
) where rownum = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment