[Solved] SQL find Peak Hour and Peak off Hour from the table

by

[ad_1]

A simple aggregate query something like this will work

SELECT COUNT(*) inserts, DATEPART(HOUR,orderreceivedTime) hour
  FROM order
 GROUP BY DATEPART(HOUR,orderreceivedTime)

[ad_2]

solved SQL find Peak Hour and Peak off Hour from the table