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

thank you but it looks very long query, is there any short version of it

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