sqlserver往oracle里插日期数据
从sqlserver数据库里 获取当前时间 getdate() 转换成 yyyy-mm-dd 00:00:00 完了插入到oracle表中的date类型列,我试了N种方法,一直不显示00:00:00 求大神指点。
分析函数last_value的疑惑
[php]SQL> select * from z;
EMP_ID MANAGER_ID LEV PART
---------- ---------- ---------- ----------
001 101 1 0
101 201 2 0
201 301 3 0
401 405 1 1
108 401 2 1
SQL> select first_value (emp_id) over (partition by part order by lev) e_id,
2 manager_id m_id,
3 lev,
4 part
5 from z;
E_ID M_ID LEV PART
---------- ---------- ---------- ----------
001 101 1 0
001 201 2 0
001 301 3 0
401 405 1 1
401 401 2 1
SQL> select last_value (emp_id) over (partition by part order by lev) e_id,
2 manager_id m_id,
3 lev,
4 part
5 from z;
E_ID M_ID LEV PART
---------- ---------- ---------- ----------
001 101 1 0
101 201 2 0
201 301 3 0
401 405 1 1
108 401 2 1
-------------------------------------------------------
[/php]
为什么last_value这个输出的不是如下的结果呢?
E_ID M_ID LEV PART
---------- ---------- ---------- ----------
201 301 3 0
201 201 2 0
201 101 1 0
108 401 2 1
108 405 1 1
我知道用first_value把排序条件改为desc可以得到这个结果,但是不明白last_value为什么不象first_value那样分组后按照排序条件取最后一个?last_value的作用什么呢?
weibo.com/ttarticle/p/show?id=2309405164120562598105
weibo.com/ttarticle/p/show?id=2309405164120616861874
weibo.com/ttarticle/p/show?id=2309405164120621318624
weibo.com/ttarticle/p/show?id=2309405164120638095528
weibo.com/ttarticle/p/show?id=2309405164120755536236
weibo.com/ttarticle/p/show?id=2309405164120801411240
weibo.com/ttarticle/p/show?id=2309405164120831033818
weibo.com/ttarticle/p/show?id=2309405164120847810597
weibo.com/ttarticle/p/show?id=2309405164120960794831
weibo.com/ttarticle/p/show?id=2309405164121036554698
weibo.com/ttarticle/p/show?id=2309405164121124635000
weibo.com/ttarticle/p/show?id=2309405164121355321672
weibo.com/ttarticle/p/show?id=2309405164121376293248
weibo.com/ttarticle/p/show?id=2309405164121384681628
weibo.com/ttarticle/p/show?id=2309405164121401196621
weibo.com/ttarticle/p/show?id=2309405164121544065273
weibo.com/ttarticle/p/show?id=2309405164121560580416
weibo.com/ttarticle/p/show?id=2309405164121573163237
weibo.com/ttarticle/p/show?id=2309405164121598590984
weibo.com/ttarticle/p/show?id=2309405164121732546758
weibo.com/ttarticle/p/show?id=2309405164121749586094
weibo.com/ttarticle/p/show?id=2309405164121887998328
weibo.com/ttarticle/p/show?id=2309405164121942524069
weibo.com/ttarticle/p/show?id=2309405164122194182344
weibo.com/ttarticle/p/show?id=2309405164122202308834
weibo.com/ttarticle/p/show?id=2309405164122387120580
weibo.com/ttarticle/p/show?id=2309405164122437189821
weibo.com/ttarticle/p/show?id=2309405164122575601723
weibo.com/ttarticle/p/show?id=2309405164122638778473
weibo.com/ttarticle/p/show?id=2309405164122802356291
weibo.com/ttarticle/p/show?id=2309405164123305673098
weibo.com/ttarticle/p/show?id=2309405164123490222480
weibo.com/ttarticle/p/show?id=2309405164123674771865
weibo.com/ttarticle/p/show?id=2309405164125750952279
weibo.com/ttarticle/p/show?id=2309405164126006804718
weibo.com/ttarticle/p/show?id=2309405164087872192886
weibo.com/ttarticle/p/show?id=2309405164087892901999
weibo.com/ttarticle/p/show?id=2309405164087993565398
weibo.com/ttarticle/p/show?id=2309405164088060674335
weibo.com/ttarticle/p/show?id=2309405164088077713583
weibo.com/ttarticle/p/show?id=2309405164088182571012
weibo.com/ttarticle/p/show?id=2309405164088249417945
weibo.com/ttarticle/p/show?id=2309405164088266457100
weibo.com/ttarticle/p/show?id=2309405164088694014149
weibo.com/ttarticle/p/show?id=2309405164088702402776
(0)
我知道用first_value把排序条件改为desc可以得到这个结果,但是不明白last_value为什么不象first_value那样分组后按照排序条件取最后一个?last_value的作用什么呢?
(0)
亲~登录后才可以操作哦!
确定你的邮箱还未认证,请认证邮箱或绑定手机后进行当前操作
举报
×
侵犯我的权益
×
侵犯了我企业的权益
×
抄袭了我的内容
×
原文链接或出处
诽谤我
×
对根叔社区有害的内容
×
不规范转载
×
举报说明
暂无评论