Use select distinct in JPQL and retrieve all columns
<p>I'm working with JPQL, I want to remove all the duplicated rows using <code>DISTINCT</code>, and at the same time retrieve all the columns in a table, I wrote something like this: </p>

<pre><code>SELECT DISTINCT cl.name, cl.age 
FROM Client AS cl
WHERE cl.country='****'
</code></pre>

<p>This query returns just the two columns <code>name</code> and <code>age</code>.</p>