write a query to display day and the total_units of electricity consumed on each day between the dates '2018-05-06' and '2018-05 | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

write a query to display day and the total_units of electricity consumed on each day between the dates '2018-05-06' and '2018-05

Sql

sql
9th Apr 2021, 9:04 AM
Ashish Katta
Ashish Katta - avatar
4 Answers
0
SELECT day, unit, SUM(unit) AS total_units FROM tableName WHERE date BETWEEN startDate AND endDate
9th Apr 2021, 10:19 AM
Akib
Akib - avatar
0
No it not working
9th Apr 2021, 10:22 AM
Ashish Katta
Ashish Katta - avatar
0
Probably cause date is not working with between.
9th Apr 2021, 10:31 AM
Akib
Akib - avatar
0
https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_between_date&ss=-1
9th Apr 2021, 10:34 AM
Akib
Akib - avatar

Often have questions like this?

Learn more efficiently, for free:

See all courses
Hot today
Python Question
3 Votes
How to learn fast C?
0 Votes
Initials of name
1 Votes
Hi everyone! I want change div with name "cd" to text(how to add url here)when I click button. No my code not worked. help me.
1 Votes
Hello, please help me understand how to solve
0 Votes
Why are the outputs appeared different?
1 Votes
How to synchronize android studio
0 Votes
I want these three dots to jump inside that box..please help
1 Votes
Forever loop pls help
0 Votes
Css In python
0 Votes