Question

Here is my SQL statement that I am trying to run in order to pull employees who were born in 1963, however I'm stumped on how to get it to be ran as ONLY the year 1963, any help would be awesome.

SELECT   FirstName, LastName, BirthDate
FROM   Employees
GROUP BY BirthDate, FirstName, LastName;

Answer 1

SELECT FirstName, LastName, BirthDate FROM Employees where BirthDate>='1963-01-01' and BirthDate<='1963-12-31' GROUP BY BirthDate, FirstName, LastName;

add the where condition as above

Note : Please comment below if you have concerns. I am here to help you

If you like my answer please rate and help me it is very Imp for me