Savitha

• Jan 12th, 2007

 

SELECT SSN,ENAME

FROM EMP

WHERE DATEDIFF(YEAR, DOB, GETDATE())>30

rekssql

 Profile Answers by rekssql Questions by rekssql

• Jan 12th, 2007

 

I wanted query in oracle sql syntax.

Vinayak

• Jan 17th, 2007

 

Select ename
from emp
where trunc(sysdate-emp.dob) > 30
/

ggk.krishna

• Feb 12th, 2007

 

Hai,SELECT ENAME FROM EMPWHERE ROUND(MONTHS_BETWEEN(SYSDATE,EMP_DOB)/12)>30I think this will work for you. If not give reply.

Srikanth

• Mar 12th, 2007

 

       select FNAME,MNAME,LNAME,BDATE
                  
        FROM EMPLOYEE

        WHERE age>30;

tomtwj

 Profile Answers by tomtwj 

• Mar 16th, 2007

 

 select   empno, BIRTHDate
 from scott.emp
 where trunc( sysdate,'YEAR') - trunC( BIRTHDate, 'YEAR') > 30

Lavanya Chowdary

• May 6th, 2007

 

For example if emp table has dob (date of birth) column the query is
SELECT * FROM EMP
WHERE months_between(sysdate,dob)/12>30;

babushiv

 Profile Answers by babushiv Questions by babushiv

• Jul 24th, 2010

 

SQL> SELECT ename FROM emp WHERE round(months_between(sysdate,DOB)/12)>=30;

 

This query will work fine as one of the user mentioned this already....

tapasgaan

 Profile Answers by tapasgaan 

• Nov 9th, 2010

 

select employeename from employee
where trunc(months-between(sysdate,dob)/12, 0) >= 30

Santhoshkandula

 Profile Answers by Santhoshkandula 

• May 18th, 2011

 

      SELECT *,DATEDIFF(YY,<JOINING DATE>,GETDATE()) AS AGE FROM <TABLE_NAME> WHERE DATEDIFF(YY,<JOINING DATE>,GETDATE()) > 30




  Thanks & Regards
  K.santhosh

maninder singh

• Apr 9th, 2012

 

Please tell me,
How to get age of all employee by using query

Ivo

• Jan 26th, 2017

 

Works great with SQL Server! Thanks!

yashwanth K S

• Apr 4th, 2017

 

Code
SELECT SSN,ENAME


FROM EMP


WHERE DATEDIFF(YEAR, DOB, GETDATE())>30

sreelatha

• May 17th, 2017

 

Code
SELECT *


FROM employee


WHERE age>30;

nisha

• Jul 7th, 2017

 

Select * from table where ((sysdate-DOB)/365)>30;

mukund

• Sep 7th, 2017

 

SELECT `First_Name`, SYSDATE(), `Date_Of_Birth`, DATEDIFF( SYSDATE(), `Date_Of_Birth` )/365
FROM `members` WHERE (DATEDIFF( SYSDATE(), `Date_Of_Birth` )/365)>15;

Piyush Kumar

• May 4th, 2019

 

Curdate() will give you the current date. here we are subtracting from dob to current date(year).

Code
SELECT * FROM USER WHERE (YEAR(CURDATE()) - YEAR(DOB))>30;

Shailesh Bhilare

• Dec 6th, 2021

 

There is a table employee (empid,empname,DOB). Get the emp count against the age bracket of less than or equal to 30 and above 30.
Could you pls give the oracle syntax for tge above Query..?