Y*x
2 楼
墙上贴消息的橱窗怎么说?谢谢
j*n
3 楼
Here is a question been asked...
先讨论一下第一题。我知道pivot的用法。但是这个考的好像和传统的不一样。我知道
的pivot一般都要和aggregate
function在一起用的。当然也可以不用aggregate function,但这样会有大量的null出
现。
我理解的题目意思是这样
1)把
colName1 colName2 colName3
s11 s12 s13
s21 s22 s23
s31 s32 s33
s41 s42 s43
变成
s11 s21 s31 s41
s12 s22 s32 s42
s13 s23 s33 s43
2) 然后用一个concatenate function 就整合成一个column了
第一步用一个procedure应该很好实现。但是用一句 SQL 做到实现整个table的转置,
我没找到答案。看你能不能提供点思路。
首先的一个困难,用case应该不行,应为根本没有unique之类的限制,case会把一列里
边等值的一起处理。
先讨论一下第一题。我知道pivot的用法。但是这个考的好像和传统的不一样。我知道
的pivot一般都要和aggregate
function在一起用的。当然也可以不用aggregate function,但这样会有大量的null出
现。
我理解的题目意思是这样
1)把
colName1 colName2 colName3
s11 s12 s13
s21 s22 s23
s31 s32 s33
s41 s42 s43
变成
s11 s21 s31 s41
s12 s22 s32 s42
s13 s23 s33 s43
2) 然后用一个concatenate function 就整合成一个column了
第一步用一个procedure应该很好实现。但是用一句 SQL 做到实现整个table的转置,
我没找到答案。看你能不能提供点思路。
首先的一个困难,用case应该不行,应为根本没有unique之类的限制,case会把一列里
边等值的一起处理。
n*w
4 楼
还是没办法?必须用active python什么的?active python/perl和cygwin里的python/
perl有什么差别?
perl有什么差别?
r*8
5 楼
I'm reinstalling the Windows XP, but my ESC key does not work. What should I
do? Is there any equivalent short key combination for ESC? I need ESC to
setup the boot sequence and other selections during installation process.
Thanks a lot,
do? Is there any equivalent short key combination for ESC? I need ESC to
setup the boot sequence and other selections during installation process.
Thanks a lot,
j*n
8 楼
I had a solution but sounds stupid, post here see if anyone has better idea.
with Data (c1, c2, c3)
AS (
SELECT 's11', 's12', 's13'
union all
select 's21', 's22', 's23'
union all
select 's31', 's32', 's33'
union all
select 's41', 's42', 's43'
)
SELECT [1] r1, [2] r2, [3] r3, [4] r4
FROM
(SELECT c1, row_number() over (order by c1) as RN
FROM data) AS SourceTable
PIVOT
(
min(c1)
FOR rn IN ([1], [2], [3], [4])
) AS PivotTable
union all
SELECT [1] r1, [2] r2, [3] r3, [4] r4
FROM
(SELECT c2, row_number() over (order by c2) as RN
FROM data) AS SourceTable
PIVOT
(
min(c2)
FOR rn IN ([1], [2], [3], [4])
) AS PivotTable
union all
SELECT [1] r1, [2] r2, [3] r3, [4] r4
FROM
(SELECT c3, row_number() over (order by c3) as RN
FROM data) AS SourceTable
PIVOT
(
min(c3)
FOR rn IN ([1], [2], [3], [4])
) AS PivotTable
with Data (c1, c2, c3)
AS (
SELECT 's11', 's12', 's13'
union all
select 's21', 's22', 's23'
union all
select 's31', 's32', 's33'
union all
select 's41', 's42', 's43'
)
SELECT [1] r1, [2] r2, [3] r3, [4] r4
FROM
(SELECT c1, row_number() over (order by c1) as RN
FROM data) AS SourceTable
PIVOT
(
min(c1)
FOR rn IN ([1], [2], [3], [4])
) AS PivotTable
union all
SELECT [1] r1, [2] r2, [3] r3, [4] r4
FROM
(SELECT c2, row_number() over (order by c2) as RN
FROM data) AS SourceTable
PIVOT
(
min(c2)
FOR rn IN ([1], [2], [3], [4])
) AS PivotTable
union all
SELECT [1] r1, [2] r2, [3] r3, [4] r4
FROM
(SELECT c3, row_number() over (order by c3) as RN
FROM data) AS SourceTable
PIVOT
(
min(c3)
FOR rn IN ([1], [2], [3], [4])
) AS PivotTable
n*w
14 楼
要在Windows server 上运行。装软件比较麻烦。
m*u
17 楼
不错,cong一下,
我的RD是3/12,希望暑假期间能收到FP notice
我的RD是3/12,希望暑假期间能收到FP notice
t*1
20 楼
RD 2/6,On fingerprint fee was accepted on 2/8
至今还没任何消息,
我在北加,会不会有地域差异,虽然同在NSC
急。。。
至今还没任何消息,
我在北加,会不会有地域差异,虽然同在NSC
急。。。
相关阅读
联想 X61s 装XP 无法休眠555,XP不能启动了,怎么才能保住C盘的文件呢装SP1前一定要对C盘error check帮忙:word 2007 里面怎么才能调用外部图片编辑软件呢?有没有人遇到IE的这个问题?64-bit 的Lenovo R61 声卡驱动Vista 的Windows Mail不让存附件的毛病谁知道吗?Gates 说双音轨的AVI如何播放其中一条音轨? (转载)我得笔记本没有WPA-TKIP得选项装系统中途退出留下个烂尾请教怎么办Help needed: "replacing invalid security IDs with default security IDs....."WindowsXPWindows comand line extends the end like Unix "\"有没有装了vista sp1的大虾?有什么感想?crazy thought: 如何降低网络下载速度?dealsea上面的那个dell vostro 200mini desktop怎么样? (转载)谁能贴一个完整版的将系统 vista 换成 XP 的操作步骤吗?如何把英文版WinXP SP2换成中文版界面?请教大家hp从vista装回xp