SQL to display records with same Year of Birth

Display employee name, designation, Dob who are born in the same year.
Emono ename Designation Dob
101 Raj Developer 24-06-1992
102 mahesh Engineer 15-06-1992
103 Rajesh Mechanic 02-02-1991
104 suresh Jr Engineer 01-01-1990
  • Interview Candidate
  • 3
  • 5425

  
Showing Answers 1 - 3 of 3 Answers

Afsar

  • Oct 25th, 2017
 

TD QUERY:
SELECT EXTRACT (YEAR FROM DOB), ename, Designation, Dob
FROM TABLE TAB1
GROUP BY EXTRACT (YEAR FROM DOB)

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions