using the criteria for finding data in grails

Question

I'm using the criteria for finding data from database and I have duplicate data in some columns. I want to show only one of them when using criteria. I can't use listDistinct because i have max and offset in the list.

Domain.createCriteria().list(max: pageSize, offset: offset) {

            distinct('column has duplicate')
        }

Any ideas to solve this problem?

Thanks!