blog迁移至 :http://www.micmiu.com
利用LAG分析函数把重复字段设置为空的示例如下:
测试表TEST_XX的数据如下:
要实现如下的输出结果:
具体的sql如下:
SELECT CASE
WHEN PRE_NAME IS NULL THEN
USER_NAME
ELSE
NULL
END AS USER_NAME,
COURSE,
GRADE
FROM (SELECT A.*,
LAG(USER_NAME) OVER(PARTITION BY USER_NAME ORDER BY COURSE) AS PRE_NAME
FROM TEST_XX A)
本文连接:http://sjsky.iteye.com/blog/1344794
转载请注明来自:Michael's blog @ http://sjsky.iteye.com
----------------------------- 分 ------------------------------ 隔 ------------------------------ 线 ------------------------------