select SName,
FName,
DOB,
DATEDIFF(YY,DOB,GETDATE()) AS AGE,
CAST(DATEDIFF(yy, DOB,getdate()) AS varchar(4)) +' Years, '+ 
CAST(DATEDIFF(mm, DATEADD(yy, DATEDIFF(yy, DOB, getdate()), DOB), getdate()) AS varchar(2)) +' Month,and '+ 
CAST(DATEDIFF(dd, DATEADD(mm, DATEDIFF(mm, DATEADD(yy, DATEDIFF(yy, DOB, getdate()), DOB), getdate()), DATEADD(yy, DATEDIFF(yy, DOB, getdate()), DOB)), getdate()) AS varchar(2)) +'Days' AS Ages 
FROM tblData

Hinauna,

There is no short version of query.

If you want to make it short then Create function and call it where you need.

Refer the below link and modify it.

Display time elapsed few seconds ago, minute ago, hours ago, days ago and year ago in SQL Server