摘要:
over partition by与group by 的区别 Over Partition by 与Group by 的区别 例如: 有三条数据 Id 1 Id 2 Id 3 group by 结果为6 over partition SUM (Id) OVER (PARTITION BY id ) 阅读全文
摘要:
SELECT convert(int,case when charindex('#',test)=0 then 0 -- 计算出test字符串后面的数字 else (select substring(test,charindex('#',ResNo)+1,10)) end ) as Num --Nu 阅读全文
摘要:
mysql: GROUP_CONCAT函数 SELECT GROUP_CONCAT(id) id FROM `task_definition` LIMIT 0,100 sql server :stuff select stuff((select ','+name+'' from table1 for 阅读全文