laokaizzz的专栏

例如某条记录 的testcol可为null, 记录有些存1，有些为

数学差 真丢人写个函数搞半天，还得用笔画

SQL字符串分组聚合(分组后的数据查询后用逗号隔开)SQL2005中的方法create table tb(id int, value varchar(10))insert into tb values(1, 'aa')insert into tb values(1, 'bb')insert into tb values(2, 'aaa')insert i

select xxx_Guid,STUFF((select ','+guigexinghao_name from  xxxx where t.xxx_Guid=xxx_Guid for xml path('')),1,1,'') from  xxxx t group by xxx_Guid

select t.*, (select count(*) from aaa where id<=t.id and diqu=t.diqu) as c from aaa t

转自http://blog.csdn.net/java2000_wl/article/details/8014414

c3p0destroy-method="close"> pom.xmldependency> groupId>c3p0groupId> artifactId>c3p0artifactId> version>0.9.1.2version>dependency>tomcat jdbcbe

执行如下语句即可： select OWNER, t.segment_name, t.segment_type, sum(t.bytes / 1024 / 1024) mmm from dba_segments t where t.owner = '你要查询的用户'  and t.segment_type='TABLE' group by OWNER, t.segment_name, t.segme...