DEFINITIONS

Definitions More Info.
Definition ID12.111
TitleSQL
CategoryNOTES
DefinitionAylara gore login sayisi- tarih araliginda
Definition DescriptionSELECT LoginId,
FORMAT(CreationDate,'yyyy-MM') AS LoginMonth,
COUNT(LoginId) AS LoginCount
FROM AdayLogDB WITH(NOLOCK)
WHERE LoginId=14796907
AND CreationDate>'2020-01-01' AND CreationDate<='2020-12-30'
GROUP BY LoginId,FORMAT(CreationDate,'yyyy-MM')
RecordBycunay
Record Date26-11-2023 20:50:28
Düzenle
Kopyala
Sil