Consider two fields B_date, which stores the birth date and J_date, which stores the joining date of an employee. Write commands to find out and display the approximate age of an employee as on today.
Answer
SELECT (YEAR(CURDATE()) - YEAR(B_DATE)) AS AGE FROM EMPLOYEE;
