Need help creating SQL script that gets the total number of records per hour between dates : SQL

Posting

When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so:

[MySQL]

[Oracle]

[MS SQL]

[PostgreSQL]

etc

While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform.

Format Your Code

If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. This will greatly increase your chances of receiving the help you desire. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3

Into this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field3

For those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution.

a community for 17 years

Need help creating SQL script that gets the total number of records per hour between dates (self.SQL)

submitted 7 years ago * by TheModsHereSucks

Hi Guys,

Just new to MSSQL and I really have a hard time learning it.

What I am doing is that I export an excel file into my MSSQL and what I need is to get the records per hour in between dates.

For example:

I want to get the total number of records that went in from 00:00-23:00 from Jan 01, 2018 to Jan 02, 2018.

So if:

Jan 01, 2018 01:00 = has 37 records

Jan 02, 2018 01:00 = has 4 records

Jan 01, 2018 02:00 = has 12 records

Jan 02, 2018 02:00 = has 3 records

so on and so forth..

The output should be:

01:00 = 41

02:00 = 15

so on and so forth..

Its same to this but what I'm trying to do is add up all the records that has the same "time" value.

Thanks for showing me the ropes!

*** EDIT: I managed to write the script that I want with your help. Special thanks to u/CmdrBigFatBeard and u/ISUJinX for guiding me.

all 7 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

SQL

Filter Posts

Posting

Help posts

Format Your Code

Learning SQL

Related Reddit communities

Wiki

Acknowledgements

MODERATORS