The SELECT clause provides more control over the result set than the from clause. If you want to obtain few properties of objects instead of the complete object, use the SELECT clause. Following is the simple syntax of using SELECT clause to get just first_name field of the Employee object:


It is notable here that Employee.firstName is a property of Employee object rather than a field of the EMPLOYEE table.

---