Mr. Som, a HR Manager in a multinational company “Star-X world” has created the following table to store the records of employees:

Question

Table: Emp

He has written following queries:

i) select max(year(DOB)) from emp;

ii) select ENAME from emp where month(DOJ)=11;

Predict the output.

OR

Based on the table given above, help Mr. Som writing queries for the following task:

i) To display the name of eldest employee and his/her date of birth.

ii) To display the name of those employees whose joining month is May.

Share with your friends

Salim Ahmed Kawsar · Answer 1 · Feb 05, 2023 15:29:48

correct answer for Q1) select max(year(DOB)) from emp;
will be 2021

Salim Ahmed Kawsar · Answer 2 · Feb 05, 2023 15:29:48

Mr. Som, a HR Manager in a multinational company “Star-X world” has created the following table to store the records of employees: Table: Emp

Output:

i) 2001

ii) Melinda

OR

Queries:

i) select ENAME,min(year(DOB)) from emp;

ii) select ENAME from emp where month(DOJ)=5;

2 Answers