Write a query to find the list of employees whos age is greater than 30 or so given a date of birth column

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..?

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;

Answer Question  Select Best Answer

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 10th, 2008

To check data loaded in the backend can be done by collecting the session results from the reposistory tablesquality of dataloaded can be done by writing sql qureries on the target table.To Check perf...

tomtwj

 Profile Answers by tomtwj Questions by tomtwj

• Mar 14th, 2007

Performance, Data quality, consistensy and exception handling, large various source types.  

Answer Question  Select Best Answer

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Jun 21st, 2012

By using BELOW SCENARIO we can do it the flow is like this
SRC-->SQ-->EXP-->T1
T2

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jun 11th, 2012

Hi Shiva,

You can use Normalizer t/f to achieve the desired output. There is an "Occur" option in Normalizer in which you can mention the no of times you want to load the same source data into target.

Answer Question  Select Best Answer