title: Duplicates in Criteria.list()
body: <pre><code>public List&lt;String&gt; listOfChunks() {
      Criteria criteria = getSession().createCriteria(Student.class);
          criteria.addOrder(Order.asc("id"));
          criteria.setProjection(Projections.sqlProjection("right(name,1) as lastChar", new String[]{"lastChar"}, new Type[]{ new StringType()}));
          return criteria.list();
      }
  </code></pre>
  
  <p>Above query is giving me last char of all the students name, how can i avoid duplicates in lastchar which I am getting in list() ?</p>