SQL query to display age range given only date of birth?

Question

SQL

I ran into a problem, I need to display the ID, Status, Title of the work and the range of the age category,
I can’t display it because the database contains only the date of birth of a person from 03/19/1958 to 2005, I can’t figure out how to make a BETWEEN request so that it automatically does range in age that is sorted from 25 let's say to 50 years old.
SELECT LoginID,MaritalStatus,BirthDate,JobTitle
FROM HumanResources.Employee where MaritalStatus='S' and JobTitle like '%Specialist' and BirthDate Between 25 and 50 (does not work, I understand that you need to specify the date of birth in this way), point out the error, thank.

Answer 1

Well, you can "head on" - calculate the age as datediff(year, BirthDate, getdate())
or even cluster it by age groups right away.
That is something like:

SELECT 
LoginID,
age_group = datediff(year, BirthDate, getdate())  -- или же кэйсом разбивать на интервалы
FROM HumanResources.Employee 
where age_group between 25 and 30

Depending on the need for an approximate age or "full years" - slightly modify datediff

Answer 2

stackoverflow.com/questions/2533890/how-to-get-an-...

Answer 3

If it is enough to cluster by tens of years, then you can do this, rounding

SELECT ROUND(datediff(YEAR, SYSDATETIME(), '19650505' ) , -1);