Viewer

 

2008年5月30日

SQL Server CTE

摘要： Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -->----------------嵌套获取员工级别 WITH CTE (EmployeeId,FullName, ManagerId, BossName, EmployeeLevel) AS (... 阅读全文

posted @ 2008-05-30 23:06 Viewer 阅读(287) 评论(0) 推荐(0) 编辑

用OVER实现统计

摘要： Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -->SELECT TJobNumber, TClientCode, TToChargePounds, SUM(TToChargePounds) OVER(PARTI... 阅读全文

posted @ 2008-05-30 23:04 Viewer 阅读(224) 评论(0) 推荐(0) 编辑

SQL Server Ranking Functions

摘要： 一共有四个Ranking Function. 作用如下： Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --> SELECT EmployeeId, FullName EmployeeName, DepartmentId... 阅读全文

posted @ 2008-05-30 22:47 Viewer 阅读(196) 评论(0) 推荐(0) 编辑

导航