How can I write a query to find duplicate entries that have 2 values (x, y) that are the same?
Because of another bug #4880 <https://github.com/orientechnologies/orientdb/issues/4880> I have been able to break my database so that I can't put back the UNIQUE index. A SQL self-join or SQL GROUP BY would come in handy right now. select x,y,count(*) from myTable group by x,y having count(*) > 1 -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
