Question

Imagine that you have a students table with the columns student_id, student_name, and birthdate. Write an Oracle SQL query to find each student's age (in years) as of today.

Answer 1

SELECT student_id, student_name,

       EXTRACT(YEAR FROM SYSDATE) - EXTRACT(YEAR FROM birthdate) AS age

FROM students;