Unique Constraint Failed, Why?

Das Goravani goravanis at gmail.com
Sat Sep 18 19:08:02 UTC 2021



> On Sep 18, 2021, at 2:19 PM, Rob Mostyn <mostyn at platformis.net> wrote:
> 
> select primarykeycolumn, count(*) 
> from table
> group by primarykeycolumn
> having count(*) > 1

I’m not familiar with doing SQL like that. I get that you want me to put in that SQL statement.. little details I don’t get exist.. 

Like do you include that comma in the first line? 

And what would this do?

And is “having” a SQL command word, usually capitalized?

Do I fetch into a list?

What should I expect to see?

Sorry

Das


More information about the omnisdev-en mailing list