Re: [RBASE-L] - Question of Group By and Having Clause

[Steve Johnson]

Thanks Tony, will give it a try using your statement. If it works, perfect.  Steve J Sent from my BlackBerry KeyOne From: anthonydl...@gmail.com Sent: January 24, 2021 11:08 PM To: rbase-l@googlegroups.com Reply-to: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Question of Group By and Having Clause 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 <sjohnson...@sprintmail.com> 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 rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/000c01d6f2c8%24be80a050%243b81e0f0%24%40sprintmail.com. -- 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 rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CABnhDAQy-z9nKD%3Dtp8sUT89H%3D90ThtwjP6NJc7nJT%2BSbENCtUw%40mail.gmail.com. -- 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 rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/5niamsqp147ji0amluc9somo.1611607239589%40sprintmail.com.