摘要: 文件高亮显示:<html><head><title>JS HightLight!</title><script type = "text/javascript" src = "js/jquery-1.5.2.js"></script>‍<script type = "text/javascript" src = "js/jquery.highlight-3.js"></script><script type = & 阅读全文
posted @ 2013-06-14 11:50 Seasons1987 阅读(3258) 评论(0) 推荐(0) 编辑
摘要: 转自:http://www.cnblogs.com/icebutterfly/archive/2009/08/05/1539657.html语法:ROW_NUMBER() OVER(PARTITION BY COLUMN ORDER BY COLUMN)简单的说row_number()从1开始,为每一条分组记录返回一个数字,这里的ROW_NUMBER() OVER (ORDER BY xlh DESC) 是先把xlh列降序,再为降序以后的没条xlh记录返回一个序号。 示例: xlh row_num 1700 1 1500 2 1085 3 710 4 row_number() OVER (PA 阅读全文
posted @ 2013-06-14 09:20 Seasons1987 阅读(277) 评论(0) 推荐(0) 编辑