Hi, anyone know how to select data daily from 9am-3pm?
I have a program to auto run hourly, but I only want to show the daily data from 9am-3pm. and also total count base on hour.
eg:
9-10am, total is 10
10-11am total is xx
and so on..
Please provide:
- database engine and version (ex. MSSQL 2008 R2)
- table definition in the form of create statement
- relevant sample data in the form of insert statement
- expected output from the sample data you provide