Link to home
Start Free TrialLog in
Avatar of Richiep86
Richiep86

asked on

Find employees aged 16 and younger in ORACLE SQL

Hi

im trying to write a query which finds any staff which are 16 or younger using  a CTE.

BIRTH_DATE <= sysdate - 16*12

This isnt working though.

Is my syntax wrong?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Richiep86
Richiep86

ASKER

Perfect!