ora-00937
MAX sql query in oracle
I have the testmax table as following : I开发者_StackOverflowJ ---------------------- ----------------------[详细]
2023-03-10 02:48 分类:问答Oracle Weird error : Unexpected error ORA-00937: not a single-group group function
Oracle Weird error : Unexpected error ORA-00937: not a single-group group function Executing from VB6 Application, using Adodb using Provider=MSDAORA.1[详细]
2023-01-29 05:01 分类:问答Cannot use Max with Count in SQL*Plus
this is my sql statement i get this error. but when i use only Max to single and without displaying other results it works. can someone help me[详细]
2023-01-04 17:43 分类:问答Maximum of averages
I\'m supposed to 开发者_如何学运维get every departments average wage and only show the department with the highest average wage. I figured out this query, but it doesn\'t work. Anyone got some ideas?[详细]
2022-12-23 00:30 分类:问答How to resolve ORA-00937: not a single-group group function when calculating percentage?
I\'m trying to get a percentage of the itemid that are available in a certain area. Using my query, I get an error ORA-00937: not a single-group group function[详细]
2022-12-18 02:52 分类:问答