`
sjk2013
  • 浏览: 2175610 次
文章分类
社区版块
存档分类
最新评论

Column \'表名.某列名\' is invalid in the select list because it is not contained in either an aggregate f

 
阅读更多
汉语:这个错误是提示'表名.某列名' 字段不在GROUP BY中
解决方案:group by 后面是要跟着的 select 中所有不是聚合函数的字段<wbr></wbr>
分享到:
评论

相关推荐

    org.xml.sax.SAXException: Invalid element

    NULL 博文链接:https://wilian.iteye.com/blog/1992365

    jacob Hiding the application window is not allowed

    设置隐试打开PPT报错 Hiding the application window is not allowed

    a project model for the FreeBSD Project.7z

    This, combined with the vast amount of dependencies in the kernel and that it is not easy to see all the consequences of a kernel change, demands developers with a relative full understanding of the ...

    FlexGraphics_V_1.79_D4-XE10.2_Downloadly.ir

    Now it is possible to define is the drawing take place via WMPaint or via the PaintTo direct call (if rcPaint contain non-empty rectangle then WMPaint in progress). - FIX: The TFlexPanel.FPaintCache ...

    微软内部资料-SQL性能优化3

    To make use of either more or less strict isolation levels in applications, locking can be customized for an entire session by setting the isolation level of the session with the SET TRANSACTION ...

    2009 达内Unix学习笔记

    ls -l (list)列表显示文件(默认按文件名排序), 显示文件的权限、硬链接数(即包含文件数,普通文件是1,目录1+)、用户、组名、大小、修改日期、文件名。 ls -t (time)按修改时间排序,显示目录和文件。 ls -lt 是...

    Senfore_DragDrop_v4.1

    Just open the forms in the IDE, then select "Ignore All" when the IDE complains that this or that property doesn't exist and finally save the forms. ------------------------------------------- 3. ...

    servlet2.4doc

    Encodes the specified URL by including the session ID in it, or, if encoding is not needed, returns the URL unchanged. -------------------------------------------------------------------------------...

    BUS Hound

    it will start capturing data early in the system startup process. &lt;br&gt;If Bus Hound is exited while stopped, no capture will occur until returning to the product and pressing Run. &lt;br&gt;Customizing...

    hibernate-shards.jar

    Thus, it is not the intent of this section to claim rights or contest your rights to work written entirely by you; rather, the intent is to exercise the right to control the distribution of derivative...

    微软内部资料-SQL性能优化2

    A reference to an invalid page (a page that is not in your working set) is referred to as a page fault. Assuming the page reference does not result in an access violation, a page fault can be either ...

    Springer.The.Developer’s.Guide.to.Debugging.2008.pdf

    4.3.1 Detecting an Invalid Write Access . . . . . 36 4.3.2 Detecting Uninitialized Memory Reads . . . . 37 4.3.3 Detecting Memory Leaks . . . . . . . 38 4.4 Example 2: Broken Calls to Memory ...

    Google C++ Style Guide(Google C++编程规范)高清PDF

    Another useful rule of thumb: it's typically not cost effective to inline functions with loops or switch statements (unless, in the common case, the loop or switch statement is never executed)....

    Universal-USB-Installer

    This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS...

    ERROR ITMS-90062: “This bundle is invalid. The value for key CFBundleShortVersionString [1.2] …

    The value for key CFBundleShortVersionString [1.2] in the Info.plist file must contain a higher version than that of the previously approved version [1.15] 明明1.2的版本号要大于1.15,怎么还会出现错误...

    WizFlow网页编辑

    GNU LESSER GENERAL PUBLIC LICENSE Version 2.1, February 1999 ... 51 Franklin Street, ...Thus, it is not the intent of this section to claim rights or contest your rights to work written entirely by you; ...

    BURNINTEST--硬件检测工具

    port locks up in the Operating System, the error is still reported. - Corrected a bug, where in rare cases, the result summary could be duplicated in a log file. - Updated license management, in ...

    Debugging Malloc Lab: Detecting Memory-Related Errors

    You may find that this global list can also allow you to be more specific in your error messages, as it is otherwise difficult to determine the difference between an overwrite of a non-payload area ...

    BobBuilder_app

    Interestingly the processor architecture plays an important role here as you can see in the performance tests as it is directly related to the sorting key time, the Core iX processors seem to be very ...

    Sakemail

    Change the generator of the message id.- Added the field MessageId and InReplyTo to the TSakMsg component.- Added the field In-Reply-To that is added to the message generated when it is &lt;&gt; ...

Global site tag (gtag.js) - Google Analytics