how to select only few coloum of table using Criteria class in hibernate

[sudhakar dhavala]

How to seect only few coloums for a table

 select  emp_id,emp_name from employee where emp_id<>0   

  
				Criteria crit = session.createCriteria(com.reports.employee.class);
				crit.add(Restrictions.ne("empId", "0"));
				crit.addOrder(Property.forName("empName").asc());
				List objList = crit.list();

  

[hayden wangg]

HQL could help to resolve this, for example:
select user.name, user.id from user where user.id>100

I'm not sure Criteria could also do this.