ChrisHunter: Ya, the age is derived from DOB. Suggest me a sql statement using Group By clause then.
Deceptikon: I want groups of employees where each group has the same age. Is it possible to sort employees according to their age? ; and not by their Date of Birth?
Suppose Employees born between 1-Jan-1985 to 31-Dec-1985 should come under one group.
And the very next set would be employees born between 1-Jan-1986 to 31-Dec-1986.