×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
