SELECT * FROM (SELECT * FROM TEST_TABLE ORDER BY dbms_random.value) WHERE rownum <= 5;
This will give 5 random rows from table.
Note from Author :
I maintain my website, write articles and reply comments because of my interest/hobby to share information and knowledge.
If you liked the post, Please
Follow me on twitter: http://twitter.com/pankajbatracom
Join My facebook page: http://www.facebook.com/pankajbatra.blog
Join me on LinkedIn: http://www.linkedin.com/in/batrapankaj
Or subscribe to updates by Email by clicking here
Related posts:
0 Responses
Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.