Prompt with the request:

SELECT DateTimeOp, SUM(Mass) FROM DataScales WHERE (DateTimeOp BETWEEN '2018.11.17 00:00' AND '2018.11.30 13:55') GROUP BY DAY(DateTimeOp)

I need to display 2 columns: date and summamassy.

  • Feel free to ask - and now how much is displayed? - Akina
  • I get an error, but if I do this: код SELECT SUM(Mass) FROM DataScales WHERE (DateTimeOp BETWEEN '2018.11.17 00:00' AND '2018.11.30 13:55') GROUP BY DAY(DateTimeOp) then everything works, but I need a column with the date to be output - Ivan Zhilnikov
  • one
    SELECT DAY (DateTimeOp) ... GROUP BY DAY (DateTimeOp) - Okdel
  • it is necessary that the column with the date is displayed . an error is issued Errors are accepted to be quoted (however, it is clear here what the error is - and, by the way, it explains what the jamb is). - Akina
  • thanks, Okdel, everything worked out! - Ivan Zhilnikov

0