数据库
myemptyname
这个作者很懒,什么都没留下…
展开
-
pl/sql developer快速输入select * from
pl/sql developer快速输入select * fromTools->Preferences->Editor->AutoReplace->选上Enabled,并Edit文件,加入以下内容: sf=select * from scf=select count(*) from s=select f=from w=where d=delete u=upda原创 2013-06-26 17:34:41 · 668 阅读 · 0 评论 -
oracle over partition by
select * from test数据:A B C 1 1 1 1 2 2 1 3 3 2 2 5 3 4 6 ---将B栏位值相同的对应的C 栏位值加总select a,b,c, SUM(C) OVER (PARTITION BY B) C_Sumfrom testA B C C_SUM 1 1 1 1 1 2 2 7 2 2 5 7...2013-03-13 14:45:07 · 103 阅读 · 0 评论 -
pl/sql developer快速输入select * from
pl/sql developer快速输入select * fromTools->Preferences->Editor->AutoReplace->选上Enabled,并Edit文件,加入以下内容: sf=select * from scf=select count(*) from s=select f=from w=where d=de...原创 2013-01-10 18:26:14 · 117 阅读 · 0 评论