Home » Interview » Technology

Write an SQL Query find number of employees according to gender whose DOB is between 01/01/1960 to 31/12/1975.

Correct Answer: SELECT COUNT(*), sex from Employees WHERE DOB BETWEEN ‘01/01/1960 ' AND ‘31/12/1975’ GROUP BY sex;

← Previous Question Next Question→

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion