Is it possible to select more rows than a table contains?

Question

I have a table than contains 100 rows. I want to select 200 items from it, using random rows to generate more results than the table has rows for:

SELECT * FROM `rows` ORDER BY RANDOM() LIMIT 200;

This query predictably returns 100 results. Is there a way to randomly select more than is actually contained in the table?

EDIT

Is there a way to select an arbitrary number of records without adding compounding join statements? For example, what if the requested count (LIMIT) of items is unknown in advance or is arbitrarily large?

Answer 1

try something like this

SELECT *
FROM `rows`
    cross join `rows`
ORDER BY RANDOM()
LIMIT 200;