MySQL Forums
Forum List  »  Spanish

Advanced Search
New Topic

Re: Consulta LIMIT
Posted by: David Stokes
Date: September 01, 2020 08:42AM

RAND() is going to return one random number and so the query result is one row.

To get 100 genuine random records you would need to run the query 100 times.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Consulta LIMIT
468
Alexandre Tulla Delgado
September 01, 2020 06:45AM
Re: Consulta LIMIT
174
David Stokes
September 01, 2020 08:42AM
Re: Consulta LIMIT
180
Alexandre Tulla Delgado
September 01, 2020 10:13AM
Re: Consulta LIMIT
190
Peter Brawley
September 01, 2020 12:08PM
Re: Consulta LIMIT
165
Alexandre Tulla Delgado
September 02, 2020 10:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.