How can filter all data in a category whose minimum value is greater than the specified value in a specified column?

[#1]

For example, in "Big Class. JMP ", all data of minimum body "weight" greater than 80 in each age group are selected by "age" column?For JSL

2020-06-21_09-31.png

Thanks!

[#2 · Accepted solution]

If I understand what you are asking...….you should be able to figure this out yourself

dt=current data table();

dt << select where(col min(:weight,:age) >80);

[#3]

Thank Jim!

Is this SQL syntax?

[#4]

SQL does have "Select" and "Where" components of it's language, what I provided to you is a 

     Select Where()

function right out of JSL