I need fetch distict records depend on a specific column.

I tried following,but i didnot get

List results = session
.createCriteria(User.class)
.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY)
.list();


i need following qry to be generated

select * from User where uid=? group by username

can any one give solution?