Advertisement
xickoh

Hora do dia em que envia e recebe mais mensagens

Jul 10th, 2018
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. Hora do dia em que envia e recebe mais:
  2. SELECT DATEPART(HOUR, data) AS Horas, count(*) AS numero FROM mensagens GROUP BY DATEPART(HOUR, data) ORDER BY numero DESC
  3.  
  4. Hora do dia em que envia mais:
  5. SELECT DATEPART(HOUR, data) AS Horas, count(*) AS numero FROM mensagens WHERE idContacto = 1 GROUP BY DATEPART(HOUR, data) ORDER BY numero DESC
  6.  
  7. Hora do dia em que recebe mais:
  8. SELECT DATEPART(HOUR, data) AS Horas, count(*) AS numero FROM mensagens WHERE idContacto != 1 GROUP BY DATEPART(HOUR, data) ORDER BY numero DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement