每日分享工作中比较常用的东西,加强记忆

1.over(partition by)开窗函数,与聚合函数的区别是聚合函数返回一行数据,该函数分组返回多组数据。

例如:

   SELECT * FROM (select t.name,t.class,t.sroce,rank() over(partition by t.class order by t.sroce desc) mm,count(*) over(partition by t.CLASS) from T2_TEMP t) ;

注:rank()跳排名 1,1,3,4。

       dense_rank连续排序 1,2,3,4。

       *row_number()有去重复的功能。排名相同的只显示一个。

       count() over(partition by ... order by ...):求分组后的总数。

   max() over(partition by ... order by ...):求分组后的最大值。
   min() over(partition by ... order by ...):求分组后的最小值。
   avg() over(partition by ... order by ...):求分组后的平均值。
   lag() over(partition by ... order by ...):取出前n行数据。  

   lead() over(partition by ... order by ...):取出后n行数据。

2.to_number()字符串强转成数字

3.sys_connect_by_path()

  比较使用行转列的函数,注意需要把表转成树的形式才可使用!

  例子:

    select MAX(substr(sys_connect_by_path(name, ','),2))  from (SELECT name,rn id,LAG(RN) OVER(ORDER BY RN) pid FROM(select temp.name,rownum rn from T2_Temp temp))  start with pid is null connect by prior id=pid

  start with 条件 connect by prior 条件,树形式。

  此例子是通过lag()把结果集转换成了树结构。很实用。

4.wm_concat()函数

    行转列select id,wm_concat(subname) from(...)group by id

5.pivot

   列转行

SELECT 'AverageCost' AS Cost_Sorted_By_Production_Days, [0], [1], [2], [3], [4]

FROM(SELECT DaysToManufacture, StandardCost     FROM Production.Product) AS SourceTable

PIVOT(AVG(StandardCost)FOR DaysToManufacture IN ([0], [1], [2], [3], [4])) AS PivotTable;


Android 增强现实介绍+常用SDK分享比较

08-28

Introductionrnrn介绍rnrn“Augmented reality (AR) is a live,direct or indirect, view of a physical, real-world environment whose elementsare augmented (or supplemented) by computer-generated sensory input such assound, video, graphics or GPS data.” – Wikipediarnrn“增强现实技术是一种实时地直接或者间接地在真实的场景中叠加一些通过计算机生成的元素的技术,例如声音,视频,图形或者GPS数据等”。——维基百科rnrnBasically, Augmented Reality providesextra information over real-world object or place. For example, watch thisvideornrn基本上,增强现实技术在真实世界的物体或者场景中提供了额外的信息。例如,http://www.youtube.com/watch?v=uR4ekLLVPFk。rnrnAugmented Reality is a combination oftwo technologies:rnrn1. Computer Visionrnrn2. Computer Graphics (3D/2D)rnrn rnrn增强现实技术由下面两个技术结合:rnrn1、 计算机视觉rnrn2、 计算机图形学(3D/2D)rnrnAugmented Reality includes twoprocesses:rnrn1. Identify Real-World Object or Placernrn2. Display extra information. Information can be SimpleText,2D/3D Object, Animated Object, Touchable / clickable object,etc.rnrn增强现实技术包含两个处理过程:rnrn1、 识别真实世界中的对象或者场景rnrn2、 展示虚拟添加上去的额外信息,例如简单的文本,2D/3D物体,动画模型,可触发点击的对象等等rnrnProcessrnrnFollowing illustration generalise theexecution process of Augmented Reality Application. Process starts with camerainput and ends with rendering virtual object on screen. AugmentedReality continuously looks for tracker/object in input frames as andwhen tracker finds, it will display virtual object on screen.rnrn下面的图概括了增强现实应用执行的过程。整个过程开始于摄像头获取视频帧,以在屏幕上渲染了虚拟物体而结束。增强现实应用不断地在输入帧中寻找标志对象,当跟踪到目标时,将会在屏幕上显示虚拟物体。(PS:当然这过程还有相当复杂的注册算法过程,以后会给大家介绍)rnrnPopular Applicationsrnrn1. Augment -3Drnrn2. Junaio Augmented Realityrnrn3. Aurecmedia – Augmented Realityrnrn4. Layarrnrn5. Satellite ARrnrn一些流行的应用:rnrn1. Augment -3D https://play.google.com/store/apps/details?id=com.ar.augmentrnrn2. Junaio Augmented Reality https://play.google.com/store/apps/details?id=com.metaio.junaiornrn3. Aurecmedia – Augmented Reality https://play.google.com/store/apps/details?id=com.aurecmedia.androidrnrn4. Layarhttps://play.google.com/store/apps/details?id=com.layarrnrn5. Satellite AR https://play.google.com/store/apps/details?id=com.agi.android.augmentedreality&hl=enrnrn rnrnPopular Business Domain rnrn1. Marketingrnrn2. Shoppingrnrn3. Educationrnrn4. Medical / Healthrnrn5. Entertainmentrnrn6. Publishingrnrn流行的商业应用:rnrn1、 市场营销rnrn2、 购物rnrn3、 教育rnrn4、 医疗卫生rnrn5、 娱乐rnrn6、 出版业rnrn……rnrnPopular SDKs for Developmentrnrn1. QualcommVuforiarnrn2. Metaiornrn3. TotalImmersion D’Fusionrnrn4. Wikitudernrn5. Stringrnrn6. ARLabrnrn著名的SDK:rnrn1. QualcommVuforia https://developer.vuforia.com/rnrn2. Metaio http://www.metaio.com/products/sdk/rnrn3. TotalImmersion D’Fusion http://www.t-immersion.com/products/dfusion-suiternrn4. Wikitude http://www.wikitude.com/developerrnrn5. String http://www.poweredbystring.com/productrnrn6. ARLabhttp://www.arlab.com/rnrnhttp://blog.csdn.net/ggtaas/article/details/17690975

没有更多推荐了,返回首页

私密
私密原因:
请选择设置私密原因
  • 广告
  • 抄袭
  • 版权
  • 政治
  • 色情
  • 无意义
  • 其他
其他原因:
120
出错啦
系统繁忙,请稍后再试