SQl Query to select two values or rows randomly - oracle

**vijay** · 02-20-2013, 09:55 AM

Please take a look at the following table and data:

Code:

value
-----
oracle
mysql
postgres
netezza
mangodb

My requirement is to select two rows randomly from the above data set. How can i to this by using a query.

**vijay** · 02-20-2013, 10:00 AM

Use the DBMS_RANDOM package to get random values.

Query using rownum:

Code:

select *
from
(
select value
from    tablename
order by DBMS_RANDOM.RANDOM
) a
where rownum <= 2;

Query using row number analytic function

Code:

select value
from
(
select value, row_number() over(order by DBMS_RANDOM.RANDOM) r
from   tablename
) a
where r <= 2;

Thread: SQl Query to select two values or rows randomly - oracle