Re: [EXTERNAL] Sql select max value question

["Art Tostaine, Jr." <atostaine@xxxxxxxxx>]

Thanks Rob.  I made my column and file names correct and I get t1.sty not
found.  I've never done WITH before.  I see that it's like a create view.

with t1 as (
select sty, max(qty) as maxqty
from whso313f
group by sty)
select m.sty, m.cls, m.qty
from whso313f m
where sty=t1.sty and m.qty=t1.qty

whso313f is sty,cls,qty

If my data was like this:

sty

Thanks again.

Art

On Tue, May 29, 2018 at 9:19 PM, Rob Berendt <rob@xxxxxxxxx> wrote:

> with t1 as (
> select style, max(qty) as maxqty
> from mytable
> group by style)
> select m.style, m.class, m.qty
> from mytable m
> where style=t1.style and m.qty=t1.qty