WDForge.org - Forums

SQL query to display the number of Females and Males

Sujet: SQL query to display the number of Females and Males
par Anonyme sur 12/9/2005 20:34:58

Good afternoon
I need help on how to build a query from an Employee table:
Employee:(EmpID,
Name,
DateofBirth,
Sex,
Department,
Hiredate
Age)
1)I would like to build a query to count the number of females and males and their total in each departement.Then display the results using a table.
For example As departments:HR, PAYROLL, ACCOUNTING,IT and Customer Service
2) Is there a way in Windev to calculate the number of years in service based on the hiredate and the current date.

My French is not that good ...sorry
Your help will be really appreciated. I am new in Windev
Thanks