When one is using this function in a query in Aster, is a random set of rows returned (assuming there is no order by specification).
Yes Sir, Every time limit will pick up randowm rows. But if you run teh same select with limit there are chances you might get a specific result set.
well, the answer in single word is YES, random set of rows are returned while limit is used.
Try for yourself.