SQL get last 6 month data

Not only 6 month you can get data as you want.

 SELECT *  
 From PIS.dbo.PIS_tblEmployeeGenInfo  
 WHERE dtJoiningDate > DATEADD(m, -6, current_timestamp)  

Popular posts from this blog

WPF Crystal Report Viewer Using SAP

ASP.NET MVC razor SAP Crystal report