how to fire select query for specified column

I have one domain class like employee(id, name,age,salary) and i want to get only name and salary.
If i tried with->

Employee.executeQuery(select e.name,e.salary from Employee e)
its giving error like property mismatch.

But if tried with->
Employee.executeQuery( from Employee e)
in this case Values are coming properly.

But my requirement is to get only few column not all column.
so please give me any solution for this problem
 

prashant.kum

New member
try this
def lst=Employee.executeQuery("select new Map(e.name as name,e.salary as salary) from Employee e")
lst.each{
println it.name
}
 
Top