sql - MySQL ERROR 1241 (21000): Operand should contain 1 column(s) on Aggregate Query -


i using mysql ver 14.14 distrib 5.5.52, debian-linux-gnu (armv7l) using readline 6.3 running on raspbian os on raspberypi 3.

i run following query , following results.

mysql> select     -> sensormeasurements.sensormeasurementdate,     -> min(sensormeasurements.sensormeasurementvalue) "minvalue",     -> max(sensormeasurements.sensormeasurementvalue) "maxvalue",     -> avg(sensormeasurements.sensormeasurementvalue) "avgvalue"     ->   sensormeasurements     ->        inner join usersystemsensors     ->                on sensormeasurements.usersystemsensorid =     ->                   usersystemsensors.usersystemsensorid     ->        inner join sensors     ->                on usersystemsensors.sensorid = sensors.sensorid     ->        inner join usersystems     ->                on usersystemsensors.usersystemid = usersystems.usersystemid     ->        inner join users     ->                on usersystems.userid = users.userid     ->  sensors.sensorid = 1     ->        , sensormeasurements.sensormeasurementdatetime between     ->            "2016-11-05 10:00:00" , "2016-11-15 11:00:00"     -> group (sensormeasurements.sensormeasurementdate);  +-----------------------+----------+----------+-------------------+  | sensormeasurementdate | minvalue | maxvalue | avgvalue          | +-----------------------+----------+----------+-------------------+  | 2016-11-05            |     66.9 |       73 | 69.56107784431138 |  | 2016-11-06            |     51.5 |     73.4 | 64.03751600512162 |  | 2016-11-07            |     40.3 |     68.7 | 58.34236111111102 |  | 2016-11-08            |     39.2 |     59.4 |  48.1092361111111 |  | 2016-11-09            |     13.2 |     54.8 | 36.78529850746269 | +-----------------------+----------+----------+-------------------+

when modify query following error error 1241 (21000): operand should contain 1 column(s) 

select  sensors.sensorname, sensormeasurements.sensormeasurementdate, min(sensormeasurements.sensormeasurementvalue) "minvalue", max(sensormeasurements.sensormeasurementvalue) "maxvalue", avg(sensormeasurements.sensormeasurementvalue) "avgvalue"   sensormeasurements         inner join usersystemsensors                 on sensormeasurements.usersystemsensorid =                    usersystemsensors.usersystemsensorid         inner join sensors                 on usersystemsensors.sensorid = sensors.sensorid         inner join usersystems                 on usersystemsensors.usersystemid = usersystems.usersystemid         inner join users                 on usersystems.userid = users.userid   sensors.sensorid = 1         , sensormeasurements.sensormeasurementdatetime between             "2016-11-05 10:00:00" , "2016-11-15 11:00:00" group (sensors.sensorname, sensormeasurements.sensormeasurementdate);

any ideas overlooking?

thanks steve

mihai's answer worked:

remove () group by


-

Comments

Post a Comment

Popular posts from this blog

java - SSE Emitter : Manage timeouts and complete() -

i writing web app multiple listeners(evcentsource sse clients js) connected server . want store sse emitter per connected listener : can done in memory or other means assigning id each client able achieve far now question ; how send response/event specific client connected web app ? while doing sseemmiters stored either getting completed or timed out. how prevent ? how keep sseemmiter available open infinite time (till client closes) , send events selectively .
Read more

jquery - uncaught exception: DataTables Editor - remote hosting of code not allowed -

i'm trying implement crud operation using datatableseditor using datatables.but i'm getting error messages: 1)uncaught exception: datatables editor - remote hosting of code not allowed. please see http://editor.datatables.net details on how purchase editor license 2)typeerror: a.editor undefined 3) $.fn.datatable.editor not constructor" what reason? here configuration: <%@ page language="java" contenttype="text/html; charset=iso-8859-1" pageencoding="iso-8859-1"%> <!doctype html public "-//w3c//dtd html 4.01 transitional//en" "http://www.w3.org/tr/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> <title>insert title here</title> <link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.12/css/jquery.datatables.min.css"> <link re...
Read more

java - How to resolve error - package com.squareup.okhttp3 doesn't exist? -

i trying convert json java object use of gson in maven, following youtube video guidance - https://www.youtube.com/watch?v=vqgghm9pwe0 , theres error occurs when in main class error - package com.squareup.okhttp3 doesn't exist. code below: java package com.codebeasty.json; import com.squareup.okhttp3.okhttpclient; public class main { private static okhttpclient client = new okhttpclient(); public static void main (string [] args) { } } i put in dependency in pom.xml: <dependencies> <dependency> <groupid>com.squareup.okhttp3</groupid> <artifactid>okhttp</artifactid> <version>3.4.2</version> </dependency> <dependency> <groupid>com.google.code.gson</groupid> <artifactid>gson</artifactid> <version>2.8.0</version> </dependency> </dependencies> i dont understand why doesn't recognize com.squareup. there may need download? have downl...
Read more