Query Builder missing "Random N rows" sample option

[#1]

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

[#2]

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.