[RBASE-L] - Re: Select where not unique

[Lawrence Lustig]

<<
I’m trying to find duplicate invoice numbers in a
table and am looking for an “is not unique” or “where not
unique” type function in 6.5++.  Am I missing it, or does it just not
exist?
>>


SELECT InvNo, COUNT(*) FROM Invoices GROUP BY InvNo HAVING COUNT(*) > 1

--
Larry