Unique Constraint Failed, Why?

[IT]

Hi Das

Run the SQL code from "SQL Browser". Select the session and open an "Interactive Sql” window.

regards

xavier


> El 18 sept 2021, a las 21:08, Das Goravani <goravanis at gmail.com> escribió:
> 
> 
> 
>> 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
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com