Sorry to bring up a question that has already been asked but the truth is I haven't found a straight (and convincing) answer yet.
JCR-SQL2 doesn't provide a SELECT DISTINCT (or similar, AFAIK). Neither do SQL or XPATH in JCR 1.0... How are people getting around this?. What's the best way of removing duplicate rows? I read that someone was iterating over the results and putting them in a Set. In my case, because of the possible huge number of results, that approach may end up being too costly. Thanks. Regards, Miguel Prieto
