- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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!
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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);
Jim
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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);
Jim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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?
Is this SQL syntax?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: 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
Jim