How to display the age of all the employees?

Question

Create nd populate the table "Employee(emp_no,dept_no,name,salary,dob,city).

Answer 1

Payal Sharma

Use DATEDIFF function in SQL

DATEDIFF(datepart, startdate, enddate) 

datepart means day, year, month, minute

So age should be in year

age = DATEDIFF(year, dob, current_date) 

Answer 2

What does the table look like? You have to provide a little more information.