Difference between revisions of "User:Pavila"

import java.util.*;
import java.nio.charset.*;

print("Charset: " + Charset.defaultCharset()+"<br/>");
print("Locale: " + Locale.getDefault()+"<br/>");

from NodeDocument nd where nd.uuid in (select ndv.parent from NodeDocumentVersion ndv group by ndv.checksum having count(ndv.checksum) > 1);
select nd.name from NodeDocument nd where nd.uuid in (select ndv.parent from NodeDocumentVersion ndv where ndv.checksum in (select ndv.checksum from NodeDocumentVersion ndv group by ndv.checksum having count(ndv.checksum) > 1))