- 浏览: 272039 次
文章分类
最新评论
-
yonghuuser:
< namespace > http://www. ...
使用 xfire 开发 web service 应用 -
悬空90:
牛人 呵呵
JCS 资料 -
悬空90:
谢谢分享 呵呵
JCS 应用 -
kuiye:
用于在客户端页面调用.
DWR util.js 整理(DWR 处理各种form表单Select/option,table等,List,Bean -
bo_hai:
好像不是原创呢!
抽象类与接口的区别
sql 代码
- select * from ( select * from(
- select sum(isnull(aa,0)) as a,sum(bb)as b,sum(cc)as c,sum(dd)as d,sum(ee)as e
- from ( select
- case c1.store_type when 1 then a1StoreCount else 0 end as aa,
- case c1.store_type when 2 then a1StoreCount else 0 end as bb,
- case c1.store_type when 3 then a1StoreCount else 0 end as cc,
- case c1.store_type when 4 then a1StoreCount else 0 end as dd,
- case c1.store_type when 5 then a1StoreCount else 0 end as ee
- from ( SELECT a1.store_type,a1.item_name, count(a1.store_id) as a1StoreCount
- FROM BIZ_PROD_PRICE p inner join
- (SELECT s.store_type,p.id,p.store_id,i.id as iid,i.item_name, pd.prod_name, pi.prod_price
- FROM BIZ_PROD_PRICE p INNER JOIN
- BIZ_PROD_PRICE_ITEM pi ON p.id = pi.main_id INNER JOIN
- dim_store s on s.id=p.store_id inner join
- dim_dict_item i on i.id=s.store_type inner join
- dim_product pd ON pd.id = pi.prod_id
- inner join dim_geography g ON s.geo_id = g.id
- inner join dim_geography g1 ON g.parent_geography_id = g1.id
- WHERE pd.id = 284 and $P!{queryString}) a1 on p.id=a1.id INNER JOIN
- (SELECT p.id,p.store_id,i.id as iid,i.item_name, pd.prod_name, pi.prod_price
- FROM BIZ_PROD_PRICE p INNER JOIN
- BIZ_PROD_PRICE_ITEM pi ON p.id = pi.main_id INNER JOIN
- dim_store s on s.id=p.store_id inner join
- dim_dict_item i on i.id=s.store_type inner join
- dim_compt_prod pd ON pd.id = pi.prod_id
- inner join dim_geography g ON s.geo_id = g.id
- inner join dim_geography g1 ON g.parent_geography_id = g1.id
- WHERE pd.id = 17 and $P!{queryString}) a2 ON a1.store_id = a2.store_id AND
- a1.prod_price > a2.prod_price and a1.iid=a2.iid
- group by a1.item_name,a1.store_type
- )c1
- )e1)d,
- (select sum(aa) as a1,sum(bb)as b1,sum(cc)as c1,sum(dd)as d1,sum(ee)as e1
- from ( select
- case c1.store_type when 1 then a1StoreCount else 0 end as aa,
- case c1.store_type when 2 then a1StoreCount else 0 end as bb,
- case c1.store_type when 3 then a1StoreCount else 0 end as cc,
- case c1.store_type when 4 then a1StoreCount else 0 end as dd,
- case c1.store_type when 5 then a1StoreCount else 0 end as ee
- from (SELECT a1.store_type,a1.item_name, count(a1.store_id) as a1StoreCount FROM
- BIZ_PROD_PRICE p inner join
- (SELECT s.store_type,p.id,p.store_id,i.id as iid,i.item_name, pd.prod_name, pi.prod_price
- FROM BIZ_PROD_PRICE p INNER JOIN
- BIZ_PROD_PRICE_ITEM pi ON p.id = pi.main_id INNER JOIN
- dim_store s on s.id=p.store_id inner join
- dim_dict_item i on i.id=s.store_type inner join
- dim_product pd ON pd.id = pi.prod_id
- inner join dim_geography g ON s.geo_id = g.id
- inner join dim_geography g1 ON g.parent_geography_id = g1.id
- WHERE pd.id = 284 and $P!{queryString}) a1 on p.id=a1.id INNER JOIN
- (SELECT p.id,p.store_id,i.id as iid,i.item_name, pd.prod_name, pi.prod_price
- FROM BIZ_PROD_PRICE p INNER JOIN
- BIZ_PROD_PRICE_ITEM pi ON p.id = pi.main_id INNER JOIN
- dim_store s on s.id=p.store_id inner join
- dim_dict_item i on i.id=s.store_type inner join
- dim_compt_prod pd ON pd.id = pi.prod_id
- inner join dim_geography g ON s.geo_id = g.id
- inner join dim_geography g1 ON g.parent_geography_id = g1.id
- WHERE pd.id = 50 and $P!{queryString}) a2 ON a1.store_id = a2.store_id AND
- a1.prod_price > a2.prod_price and a1.iid=a2.iid and p.id=a2.id
- group by a1.item_name,a1.store_type
- )c1
- )e2)d1,
- (
- select sum(aa) as a2,sum(bb)as b2,sum(cc)as c2,sum(dd)as d2,sum(ee)as e2
- from ( select
- case c1.store_type when 1 then a1StoreCount else 0 end as aa,
- case c1.store_type when 2 then a1StoreCount else 0 end as bb,
- case c1.store_type when 3 then a1StoreCount else 0 end as cc,
- case c1.store_type when 4 then a1StoreCount else 0 end as dd,
- case c1.store_type when 5 then a1StoreCount else 0 end as ee
- from (SELECT a1.store_type,a1.item_name,count(a1.store_id) as a1StoreCount FROM
- BIZ_PROD_PRICE p inner join
- (SELECT s.store_type,p.id,p.store_id,i.id as iid,i.item_name, pd.prod_name, pi.prod_price
- FROM BIZ_PROD_PRICE p INNER JOIN
- BIZ_PROD_PRICE_ITEM pi ON p.id = pi.main_id INNER JOIN
- dim_store s on s.id=p.store_id inner join
- dim_dict_item i on i.id=s.store_type inner join
- dim_product pd ON pd.id = pi.prod_id
- inner join dim_geography g ON s.geo_id = g.id
- inner join dim_geography g1 ON g.parent_geography_id = g1.id
- WHERE pd.id = 343 and $P!{queryString}) a1 on p.id=a1.id INNER JOIN
- (SELECT p.id,p.store_id,i.id as iid,i.item_name, pd.prod_name, pi.prod_price
- FROM BIZ_PROD_PRICE p INNER JOIN
- BIZ_PROD_PRICE_ITEM pi ON p.id = pi.main_id INNER JOIN
- dim_store s on s.id=p.store_id inner join
- dim_dict_item i on i.id=s.store_type inner join
- dim_compt_prod pd ON pd.id = pi.prod_id
- inner join dim_geography g ON s.geo_id = g.id
- inner join dim_geography g1 ON g.parent_geography_id = g1.id
- WHERE pd.id = 22 and $P!{queryString}) a2 ON a1.store_id = a2.store_id AND
- a1.prod_price > a2.prod_price and a1.iid=a2.iid
- group by a1.item_name,a1.store_type
- )c1
- )e3)d2,
- (
- select sum(aa) as a3,sum(bb)as b3,sum(cc)as c3,sum(dd)as d3,sum(ee)as e3
- from ( select
- case c1.store_type when 1 then a1StoreCount else 0 end as aa,
- case c1.store_type when 2 then a1StoreCount else 0 end as bb,
- case c1.store_type when 3 then a1StoreCount else 0 end as cc,
- case c1.store_type when 4 then a1StoreCount else 0 end as dd,
- case c1.store_type when 5 then a1StoreCount else 0 end as ee
- from (SELECT a1.store_type,a1.item_name,count(a1.store_id) as a1StoreCount FROM
- BIZ_PROD_PRICE p inner join
- (SELECT s.store_type,p.id,p.store_id,i.id as iid,i.item_name, pd.prod_name, pi.prod_price
- FROM BIZ_PROD_PRICE p INNER JOIN
- BIZ_PROD_PRICE_ITEM pi ON p.id = pi.main_id INNER JOIN
- dim_store s on s.id=p.store_id inner join
- dim_dict_item i on i.id=s.store_type inner join
- dim_product pd ON pd.id = pi.prod_id
- inner join dim_geography g ON s.geo_id = g.id
- inner join dim_geography g1 ON g.parent_geography_id = g1.id
- WHERE pd.id = 341 and $P!{queryString}) a1 on p.id=a1.id INNER JOIN
- (SELECT p.id,p.store_id,i.id as iid,i.item_name, pd.prod_name, pi.prod_price
- FROM BIZ_PROD_PRICE p INNER JOIN
- BIZ_PROD_PRICE_ITEM pi ON p.id = pi.main_id INNER JOIN
- dim_store s on s.id=p.store_id inner join
- dim_dict_item i on i.id=s.store_type inner join
- dim_compt_prod pd ON pd.id = pi.prod_id
- inner join dim_geography g ON s.geo_id = g.id
- inner join dim_geography g1 ON g.parent_geography_id = g1.id
- WHERE pd.id = 22 and $P!{queryString}) a2 ON a1.store_id = a2.store_id AND
- a1.prod_price > a2.prod_price and a1.iid=a2.iid
- group by a1.item_name,a1.store_type
- )c1
- )e4)d3,
- (
- select sum(aa) as a4,sum(bb)as b4,sum(cc)as c4,sum(dd)as d4,sum(ee)as e4
- from (
- select
- case c1.store_type when 1 then a1StoreCount else 0 end as aa,
- case c1.store_type when 2 then a1StoreCount else 0 end as bb,
- case c1.store_type when 3 then a1StoreCount else 0 end as cc,
- case c1.store_type when 4 then a1StoreCount else 0 end as dd,
- case c1.store_type when 5 then a1StoreCount else 0 end as ee
- from
- (SELECT a1.store_type,a1.item_name,count(a1.store_id) as a1StoreCount
- FROM
- BIZ_PROD_PRICE p inner join
- (SELECT s.store_type,p.id,p.store_id,i.id as iid,i.item_name, pd.prod_name, pi.prod_price
- FROM BIZ_PROD_PRICE p INNER JOIN
- BIZ_PROD_PRICE_ITEM pi ON p.id = pi.main_id INNER JOIN
- dim_store s on s.id=p.store_id inner join
- dim_dict_item i on i.id=s.store_type inner join
- dim_product pd ON pd.id = pi.prod_id
- inner join dim_geography g ON s.geo_id = g.id
- inner join dim_geography g1 ON g.parent_geography_id = g1.id
- WHERE pd.id = 345 and $P!{queryString}) a1 on p.id=a1.id INNER JOIN
- (SELECT p.id,p.store_id,i.id as iid,i.item_name, pd.prod_name, pi.prod_price
- FROM BIZ_PROD_PRICE p INNER JOIN
- BIZ_PROD_PRICE_ITEM pi ON p.id = pi.main_id INNER JOIN
- dim_store s on s.id=p.store_id inner join
- dim_dict_item i on i.id=s.store_type inner join
- dim_compt_prod pd ON pd.id = pi.prod_id
- inner join dim_geography g ON s.geo_id = g.id
- inner join dim_geography g1 ON g.parent_geography_id = g1.id
- WHERE pd.id = 22 and $P!{queryString}) a2 ON a1.store_id = a2.store_id AND
- a1.prod_price > a2.prod_price and a1.iid=a2.iid
- group by a1.item_name,a1.store_type
- )c1
- )e5)d4
- )w1,
- ---lower-----------------------------------------------------------------
- ( select * from(
- select sum(isnull(aa,0)) as sa,sum(bb)as sb,sum(cc)as sc,sum(dd)as sd,sum(ee)as se from (
- select
- case c1.store_type when 1 then a1StoreCount else 0 end as aa,
- case c1.store_type when 2 then a1StoreCount else 0 end as bb,
- case c1.store_type when 3 then a1StoreCount else 0 end as cc,
- case c1.store_type when 4 then a1StoreCount else 0 end as dd,
- case c1.store_type when 5 then a1StoreCount else 0 end as ee
- from ( SELECT a1.store_type,a1.item_name, count(a1.store_id) as a1StoreCount FROM
- BIZ_PROD_PRICE p inner join
- (SELECT s.store_type,p.id,p.store_id,i.id as iid,i.item_name, pd.prod_name, pi.prod_price
- FROM BIZ_PROD_PRICE p INNER JOIN
- BIZ_PROD_PRICE_ITEM pi ON p.id = pi.main_id INNER JOIN
- dim_store s on s.id=p.store_id inner join
- dim_dict_item i on i.id=s.store_type inner join
- dim_product pd ON pd.id = pi.prod_id
- inner join dim_geography g ON s.geo_id = g.id
- inner join dim_geography g1 ON g.parent_geography_id = g1.id
- WHERE pd.id = 284 and $P!{queryString}) a1 on p.id=a1.id INNER JOIN
- (SELECT p.id,p.store_id,i.id as iid,i.item_name, pd.prod_name, pi.prod_price
- FROM BIZ_PROD_PRICE p INNER JOIN
- BIZ_PROD_PRICE_ITEM pi ON p.id = pi.main_id INNER JOIN
- dim_store s on s.id=p.store_id inner join
- dim_dict_item i on i.id=s.store_type inner join
- dim_compt_prod pd ON pd.id = pi.prod_id
- inner join dim_geography g ON s.geo_id = g.id
- inner join dim_geography g1 ON g.parent_geography_id = g1.id
- WHERE pd.id = 17 and $P!{queryString}) a2 ON a1.store_id = a2.store_id AND
- a1.prod_price <= a2.prod_price and a1.iid=a2.iid
- group by a1.item_name,a1.store_type
- )c1 )e1)d,
- (select sum(aa) as sa1,sum(bb)as sb1,sum(cc)as sc1,sum(dd)as sd1,sum(ee)as se1
- from ( select
- case c1.store_type when 1 then a1StoreCount else 0 end as aa,
- case c1.store_type when 2 then a1StoreCount else 0 end as bb,
- case c1.store_type when 3 then a1StoreCount else 0 end as cc,
- case c1.store_type when 4 then a1StoreCount else 0 end as dd,
- case c1.store_type when 5 then a1StoreCount else 0 end as ee
- from
- (SELECT a1.store_type,a1.item_name, count(a1.store_id) as a1StoreCount
- FROM
- BIZ_PROD_PRICE p inner join
- (SELECT s.store_type,p.id,p.store_id,i.id as iid,i.item_name, pd.prod_name, pi.prod_price
- FROM BIZ_PROD_PRICE p INNER JOIN
- BIZ_PROD_PRICE_ITEM pi ON p.id = pi.main_id INNER JOIN
- dim_store s on s.id=p.store_id inner join
- dim_dict_item i on i.id=s.store_type inner join
- dim_product pd ON pd.id = pi.prod_id
- inner join dim_geography g ON s.geo_id = g.id
- inner join dim_geography g1 ON g.parent_geography_id = g1.id
- WHERE pd.id = 284 and $P!{queryString}) a1 on p.id=a1.id INNER JOIN
- (SELECT p.id,p.store_id,i.id as iid,i.item_name, pd.prod_name, pi.prod_price
- FROM BIZ_PROD_PRICE p INNER JOIN
- BIZ_PROD_PRICE_ITEM pi ON p.id = pi.main_id INNER JOIN
- dim_store s on s.id=p.store_id inner join
- dim_dict_item i on i.id=s.store_type inner join
- dim_compt_prod pd ON pd.id = pi.prod_id
- inner join dim_geography g ON s.geo_id = g.id
- inner join dim_geography g1 ON g.parent_geography_id = g1.id
- WHERE pd.id = 50 and $P!{queryString}) a2 ON a1.store_id = a2.store_id AND
- a1.prod_price <= a2.prod_price and a1.iid=a2.iid and p.id=a2.id
- group by a1.item
发表评论
-
数据库设计3NF
2007-08-12 17:47 2754数据库的设计范式是数据库设计所需要满足的规范,满足这些规范的数 ... -
jdbc事务处理
2007-08-08 23:44 12020在JDBC的数据库操作中,一项事务是由一条或是多条表达式所组成 ... -
SQL SERVER 数据库无法连接
2007-07-07 19:53 2714本来运行一切正常的程序,换了一台服务器,一连报错: 2 ... -
SQL Server安装:以前的某个程序安装已在安装计算机上创建挂起的文件操作
2007-07-06 14:20 1777打开注册表编辑器,在HKEY_LOCAL_MACHINE\SY ... -
sql 整理(二)
2007-06-05 11:10 1366sql 代码 1、********************** ... -
sql 整理(一)
2007-06-05 10:59 11101、***************************** ...
相关推荐
SQL跟踪后,用该工具能够快速整理出整洁的SQL,减少人工的复制、帖贴
SqlServer索引碎片整理脚本,提据库查询效率,很有用。
自制SQL文整理,非开源,非完整,写得很挫,有使用时限,强烈不建议下载
《SQL》基本语句整理大全
对Sql语句的格式进行整理,使其易读。 操作简单,只需拷贝Sql语句,执行整理程序,然后再粘贴,就成为格式清晰的Sql语句了。
SQL Server面试常用sql整理
SQL格式整理工具,而且还可以把SQL语句转换成VB DELPHI C# JAVA里面用的格式
数据库整理工具 SQLserver专业数据整理
一些sql整理实例 sql整理实例 sql整理实例
很实用的sql语句整理工具,把杂乱的语句变得规范和易读。
SQLSERVER基础实用必会SQL语句整理.docx
sql语句整理 sql增删改查 更新数据记录 删除数据记录
经典sql语句整理大全 喜欢的朋友可以下来看看 纯文字版 比较小
DBA日常维护SQL整理,涵盖操作系统、存储、数据库各个层面
自己整理的sql常用语句,比较适合0接触学习sql的人
我最近在CSDN上学的SQL笔记.如有错误请多多指教.
sql优化总结,针对一般sql语句的优化编写进行总结整理,有助于形成良好的sql语句书写习惯
网上找的并汇总整理的SQL日期函数语句,应该比较全面了希望对大家有用
sqllice,一个自动整理SQL文格式的工具,很好用的,适合各语言的开发人员。
SQL Server 2005索引碎片整理