sql语句
文章平均质量分 77
hqmln
这个作者很懒,什么都没留下…
展开
-
sql语句
1.oracle中的语句connect by 、prior、start with的用法select * from (select * from (select * from cms_category where site_id = 'www' and (...原创 2012-07-04 16:11:09 · 84 阅读 · 0 评论 -
不错sql
--0表示没有问题 1表示有问题select * from(select v0.uuid,v0.name, (case when is_operate=1 then (case when v4.oo_score>=60 then (case when v0.oo_cost>0 then 0 else 1 end) else (case wh...原创 2014-05-14 10:42:00 · 70 阅读 · 0 评论 -
批量更新sql
update nation_scoreinfo ns set ns.tt_case=decode(ns.tt_case,'05','06',ns.tt_case) , ns.oo_case=decode(ns.oo_case,'05','06',ns.oo_case) , ns.gg_case=decode(ns.gg_case,'05','06',ns.gg_ca...原创 2014-07-06 14:31:07 · 81 阅读 · 0 评论 -
多表批量更新记录
--创建备份表create table NATION_SCOREINFO_TEST as select * from NATION_SCOREINFO select * from nation_scoreinfo_test--查询报名和成绩姓名不一样select ne.uuid as neuuid ,ne.name,ns.name,ns.uuid as nsuuid...原创 2014-07-06 16:57:00 · 128 阅读 · 0 评论 -
统计报表的sql
统计报表sql select t2.checkunit_uuid, t2.checkunit_zone, count(t.uuid) as atotal, sum(decode(t.get_card_status, 1, 1, 0)) as getTocal, sum(decode(t.get_card_stat...原创 2014-08-07 13:48:52 · 304 阅读 · 0 评论 -
简单的行列转换
select t.name, t.careerworkname, t.sup_lev, sum(decode(t.exam_date, to_date('2014-08-12', 'yyyy-MM-dd'), ...原创 2014-08-08 10:55:22 · 103 阅读 · 0 评论 -
oracle查找重复数据和删除重复数据sql
查找重复数据sql(思路就是根据需要判断重复数据的字段分组,根据having大于2的就是重复的)--查找某表重复数据select BUSS_TYPE_ID, BUSS_TYPE, TRADE_VARIETY_ID, TRADE_VARIETY, TRADE_SUBVARIETY_ID, T...原创 2017-02-14 10:56:43 · 261 阅读 · 0 评论