I'm using openJpa and want to use a distinct query on 2 columns.
If I write in native sql "SELECT DISTINCT columname2, columname3 FROM TABLE" I get unique values.
When I write in jpql language: "SELECT DISTINCT t. columname2, t.columname3 FROM TABLE t" I don't get unique values. It just returns all values.
The query should return all unique rows. How can I achieve this with openJpa?
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop