I'm on my mobile so I'll be brief. You could use project, than remove unwanted rows. Project temporary scantable using all The above statement can also contain a where clause to limit by a date for instance next remove unwanted from temp table DELETE ROWS FROM scantable WHERE SCANID IN (SELECT SCANID FROM mainscantable GROUP BY scanid HAVING COUNT(scanid) < 20)
Just as a quick thought On Mon, Jan 25, 2021, 1:18 PM Steve Johnson <[email protected]> wrote: > Is there a means to take the statement below and extract the data from the > driving table to either create a temporary table/view and/or drive a report > directly? > > > > The goal is to have the report provide the detail for only those instances > where the SCANID exceeds the count number. An ordinary WHERE clause will > display each instance of a unique SCANID in addition to multiple instances > of the same SCANID when the report is defined correctly, which I currently > have. But the report is long due to single occurrences of SCANID and I am > only interested in multiple occurrences of SCANID. Seems like a temporary > table/view would be ideal to drive the report. > > > > SELECT scanid COUNT(*) FROM scan1 GROUP BY scanid HAVING COUNT(*) > 20 > > > > Thank You > > > > Steve Johnson > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/000c01d6f2c8%24be80a050%243b81e0f0%24%40sprintmail.com > <https://groups.google.com/d/msgid/rbase-l/000c01d6f2c8%24be80a050%243b81e0f0%24%40sprintmail.com?utm_medium=email&utm_source=footer> > . > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CABnhDAQy-z9nKD%3Dtp8sUT89H%3D90ThtwjP6NJc7nJT%2BSbENCtUw%40mail.gmail.com.
