`

is invalid in the select list because it is not contained in either an aggregate

SQL Server 
阅读更多
当select 语句块中出现function与常列时，需要在where语句块之后加入group by语句，否则会报错
SELECT id, COUNT(name)
FROM t_student
WHERE sequence in(SELECT MIN(sequence) FROM t_student)
GROUP BY name,id

select语句块中出现的function(column_name)，需要在group by中捕捉该列
分享到：
| MySQL事务隔离级别详解
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    GetImageExamples_IS_invalid_not_an_this_

    This is not an invalid description.

    jacob Hiding the application window is not allowed

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

    微软内部资料-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 ...

    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 ...

    2009 达内Unix学习笔记

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

    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，怎么还会出现错误...

    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 ...

    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. ...

    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...

    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; ...

    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 ...

    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)....

    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 ...

    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 ...

    BUS Hound

    In the event the system is restarted, it will start capturing data early in the system startup process. <br>If Bus Hound is exited while stopped, no capture will occur until returning to the ...

    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 ...

    VclZip pro v3.10.1

    - If a file does not extend beyond any of the original limitations (filesizes of 4 gig or 65535 files) then no Zip64 format information is included in the archive. - property isZip64 - tells you when ...

    NewSID（光学习一下代码就可以了，没看清楚介绍别运行）

    When the SID is found in a value it is replaced with the new computer SID, and when the SID is found in a name, the key and its subkeys are copied to a new subkey that has the same name except with ...

    asp.net mvc

    This allows the validation scripts to be included either at the top of the page or at the bottom, because the scripts will look for the variable and load the metadata when it is available. ...

Magicbox
Global site tag (gtag.js) - Google Analytics