DEFINITIONS

Definitions More Info.
Definition ID892
TitleSQL_WORK
CategoryNOTES
Definitionhugin sorun olabilecek cihazlar
Definition DescriptionSELECT COUNT(UserName)AS SAYI,UserName
FROM [NebimV3Master].[DBO].[trUserLog]
--WHERE EventDate BETWEEN '20180918' AND '20180919' –tarih aralığında görmek istersen
GROUP BY UserName
--HAVING COUNT(UserName)>1000000
ORDER BY SAYI DESC
RecordBycunay
Record Date02-10-2018 17:19:22
Düzenle
Kopyala
Sil