Select substring(Downloading_Date,7,2)+'/'+substring(Downloading_Date,5,2)+'/'+substring(Downloading_Date,1,4) Downloading_Date, Count(1) TotalCount
From DWN_AdmitCard_Details DA Inner Join DownloadType_Master As DM On DA.AdmitCard_Type = DM.Download_TypeID
Where Adv_Code='202' and AdmitCard_Type='P'
Group by Downloading_Date
order by Downloading_Date Desc
Here is my query it is taking too much time to execute and fetch the record from database is there any suggestion how should i speed up my query
New contributor
Sourav Choudhary is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1