I have the testmax table as following : I开发者_StackOverflowJ ---------------------- ----------------------
Oracle Weird error : Unexpected error ORA-00937: not a single-group group function Executing from VB6 Application, using Adodb using Provider=MSDAORA.1
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
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?
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
加载中,请稍侯......