HkEndless
- 浏览: 97588 次
- 性别:
- 来自: 上海
-
文章分类
- 全部博客 (133)
- jQuery (11)
- XML (3)
- 组件 (1)
- JAVA (20)
- WEB (3)
- SPRING (6)
- HIBERNATE (5)
- AJAX (2)
- JS (1)
- JAVA webservice (1)
- Ditu (1)
- WEBSITE (1)
- HIBERNATE ANNOTATION (1)
- 排序 (1)
- TCP_NODELAY (1)
- ConvertUtils (1)
- Logistics (1)
- SQL SERVER 中identity (4)
- sql server (35)
- MYSQL (1)
- Eclipse (6)
- ORACLE (6)
- FLEX (4)
- notepad++ (0)
- UNION ALL (1)
- JUnit (3)
- SQL 异常处理 (1)
- @@trancount (1)
- IOS (1)
- ORA-02266 (1)
- REMOTE DESKTOP (0)
- HTML 优化 (1)
- CRLF (1)
- SQL Server Sequence (1)
最新评论
-
zjuttsw：
看的舒服
重要的hashcode equals转载
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中捕捉该列
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中捕捉该列
分享到：
发表评论
-
WITH (NOLOCK)
2014-09-28 11:56 574http://www.cnblogs.com/henw/arc ... -
SQL Server Profiler使用方法
2014-05-21 16:55 605http://lyt7599.blog.163.com/blo ... -
SQL Server Error Message
2014-05-20 20:20 1291http://www.sql-server-helper.co ... -
SQL锁的概述
2014-05-16 14:39 403http://blog.csdn.net/htl258/art ... -
SET...
2013-12-31 11:16 314http://msdn.microsoft.com/en-us ... -
DATE
2013-12-30 15:23 442http://blog.csdn.net/dba_huangz ... -
DATE AND TIME
2013-12-30 14:22 545SELECT (CAST((SELECT SUBSTRING( ... -
Microsoft SQL Server, Error:9002
2013-09-25 17:48 1027一般在建立一个database之后，就应该手动设置其日志的增长 ... -
SQL 2005 with(nolock)详解
2013-08-26 15:46 576http://hi.baidu.com/gabriel/ite ... -
EXISTS AND NOT EXISTS
2013-07-16 14:51 456EXISTS或者NOT EXISTS是把主查询的字段传到后边的 ... -
A interesting article for printing statement in sql
2013-07-09 11:57 420http://bytes.com/topic/sql-serv ... -
Good net website blog for Database
2013-07-09 11:53 766http://www.bluegecko.net/mysql/ ... -
how to search a function or sto in database
2013-07-08 14:02 674SELECT * FROM sysobjects WHERE ... -
Good SQL WEBSITE 细说Sql Server中的视图(上)(更新)
2013-07-08 11:38 508http://www.cnblogs.com/xbf321/a ... -
SQLServer : EXEC和sp_executesql的区别
2013-07-08 11:36 540http://www.cnblogs.com/xbf321/a ... -
Search for a stored procedure
2013-07-08 11:27 625September 3, 2007 by Pinal Dave ... -
TRUNCATE TABLE
2013-06-27 10:43 468默认情况下，IDENTITY_INSER就是off 这种情况下 ... -
SELECT INTO 和 INSERT INTO SELECT 两种表复制语句
2013-06-18 14:08 543http://www.cnblogs.com/freshman ... -
安装了SQL以后，编写SQL语句没有提示
2013-06-18 09:55 551安装了SQL以后，编写SQL语句没有提示解决办法： 工具— ... -
局部临时表VS全局临时表
2013-06-13 14:37 3649http://blog.csdn.net/wu_qiongle ...
相关推荐
InvalidSignature-The signature is invalid(解决方案).md
设置隐试打开PPT报错 Hiding the application window is not allowed
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 ...
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，怎么还会出现错误...
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 ...
标题中的"GetImageExamples_IS_invalid_not_an_this_"可能是一个编程或软件开发相关的示例集合，但根据描述，"This is not an invalid description."这似乎是一个误输入或者有误的描述，因为一个无效的描述通常意味...
ls -l (list)列表显示文件(默认按文件名排序)， 显示文件的权限、硬链接数(即包含文件数,普通文件是1，目录1+)、用户、组名、大小、修改日期、文件名。 ls -t (time)按修改时间排序，显示目录和文件。 ls -lt 是...
如果在打开某一程序时出现错误提示：Not found the kernel library or the kernel library is invalid，那是因为缺少相应的内核文件所致，解决方法很简单，将相应的库文件krnln.fnr和shell.fne和程序放在...
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 ...
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. ...
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...
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; ...
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...
InvalidArgument-The argument is invalid(解决方案).md
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 ...
+ if the data set is sorted, all interpolations are now marked invalid as they should be. + "Apply to All" did not necessarily force the current attributes of a graph to the current graph (only if...
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 ...
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)....
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 ...