topic Query Builder missing "Random N rows" sample option in Discussions

Query Builder missing "Random N rows" sample option

cgoggin — Wed, 16 Jul 2025 17:21:30 GMT

Hi,

I've noticed with JMP 18.1.2 and MySQL ODBC 8.1 Unicode driver that I'm not seeing the option to sample the result set by a random number of rows. Is this an option that was dropped from JMP or the driver? Is there a way to get it back in query builder?

Thanks

Re: Query Builder missing "Random N rows" sample option

bryan_boone — Fri, 18 Jul 2025 14:34:46 GMT

JMP doesn't seem support this with My SQL since it's not builtin natively in the database.

It would be a new feature.

Feel free to add it to the wish list.

In the meantime, you can mimic it with custom SQL with something likeL

SELECT * FROM your_table
ORDER BY RAND()
LIMIT n;

That might work.