274644_en-US

liliconcom

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

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

 

Thanks!

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

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

Re: How can filter all data in a category whose minimum value is greater than the specified value in a specified column?Thank Jim!

Is this SQL syntax?Re: How can filter all data in a category whose minimum value is greater than the specified value in a specified column?

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);