1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
|
select
DATEPART(HOUR, dateinscription) as heure,DATEPART(DAY, dateinscription) as jour, DATEPART(MONTH, dateinscription) as mois,DATEPART(YEAR, dateinscription) as annee,,count(numcompte) as nb_inscription,LANGUEUTILISEE
from
inscription
where
langueutilisee = 'FR'
and
(dateinscription<= Convert(datetime,Convert(varchar,'05/01/2016 16:37:53',103),103)
and
dateinscription>= Convert(datetime,Convert(varchar,'04/01/2016 16:37:53',103),103))
group by
DatePart(hour, dateinscription),DatePart(year, dateinscription) , LANGUEUTILISEE, DATEPART(DAY, dateinscription), DATEPART(MONTH, dateinscription)
order by
DatePart(hour, dateinscription) desc,DATEPART(DAY, dateinscription) ,DATEPART(MONTH, dateinscription), DatePart(year, dateinscription) desc, LANGUEUTILISEE DESC |
Partager