Fork me on GitHub

04 2012 档案

摘要:语法:ROW_NUMBER() OVER(PARTITION BY COLUMN ORDER BY COLUMN)简单的说row_number()从1开始,为每一条分组记录返回一个数字,这里的ROW_NUMBER() OVER (ORDER BY xlh DESC) 是先把xlh列降序,再为降序以后的没条xlh记录返回一个序号。示例:xlh row_num1700 11500 21085 3710 4row_number() OVER (PARTITION BY COL1 ORDER BY COL2)表示根据COL1分组,在分组内部根据 COL2排序,而此函数计算的值就表示每组内部排序后的顺序 阅读全文
posted @ 2012-04-15 11:54 木宛城主 阅读(276) 评论(0) 推荐(0) 编辑
摘要:HTML{ display : sDisplay }Scriptingobject.style.display [ = sDisplay ]Possible ValuessDisplayString that specifies or receives one of the following values.blockObject is rendered as a block element.noneObject is not rendered.inlineDefault. Object is rendered as an inline element sized by the dimensi 阅读全文
posted @ 2012-04-05 19:43 木宛城主 阅读(348) 评论(0) 推荐(1) 编辑

multifunction lasers
访问人数