Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions

所需积分/C币:43 2015-08-28 23:02:15 16.96MB PDF
6
收藏 收藏
举报

Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions,英文版
Microsoft Microsoft SQL Server 2012 High-Performance T-SQL Using window Functions Itzik ben-Gan Published with the authorization of Microsoft Corporation by O'Reilly Media, Inc 1005 Gravenstein Highway North Sebastopol, California 95472 Copyright 2012 by Itzik Ben-Gan All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher SBN:978-0-7356-5836-3 123456789LS|765432 Printed and bound in the united states of america Microsoft Press books are available through booksellers and distributors worldwide. If you need support related tothisbook,emailMicrosoftPressBookSupportatmspinput@microsoft.com.Pleasetelluswhatyouthinkof thisbookathttp://www.microsoft.com/learning/booksurvey Microsoftandthetrademarkslistedathttp://www.microsoft.com/aboutlegal/en/us/intellectualproperty/ Trademarks/EN-US. aspx are trademarks of the microsoft group of companies. All other marks are property of their respective owners The example companies, organizations, products, domain names, email addresses, logos, people, places, and events depicted herein are fictitious. no association with any real company, organization, product, domain name email address, logo, person, place, or event is intended or should be inferred This book expresses the author's views and opinions. The information contained in this book is provided without any express, statutory, or implied warranties. Neither the authors, O'Reilly Media, Inc, Microsoft Corporation, nor its resellers or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book Acquisitions and developmental Editor: Ken Jones Production Editor: Kristen Borg Production Services: Curtis Philips Technical Reviewer: Adam machanic Copyeditor: Roger Leblanc Indexer: Lucie haskins Cover Design: Twist Creative. Seattle Cover Composition: Karen Montgomery Illustrators: robert romano and rebecca demarest To the quartet. O1 Contents at a glance Foreword Introduction CHAPTER 1 SQL Windowing CHAPTER 2 A Detailed look at window functions 33 CHAPTER 3 Ordered set functions 81 CHAPTER 4 Optimization of Window Functions 101 CHAPTER 5 T-SQL Solutions Using Window Functions 133 Index 211 Contents Foreword Introduction Chapter 1 SQL Windowing Background of Window Functio 2 Window Functions Described 2 Set-Based vs Iterative/Cursor Programming Drawbacks of alternatives to window functions .11 A Glimpse of Solutions Using Window Function 15 Elements of window Functions 19 Partitioning .20 Ordering ramIng 22 Query Elements Supporting Window Functions ...23 Logical Query Processing Clauses Supporting Window Functions 25 Circumventing the Limitations 28 Potential for additional filters 30 Reuse of window definitions Summary 32 Chapter 2 A Detailed Look at Window Functions 33 Window Aggregate Functions Window Aggregate Functions Described Supported Windowing el 34 What do you think of this book? We want to hear from you! Microsoft is interested in hearing your feed back so we can continually improve our books and learning resources for you. To participate in a brief online survey, please visit microsoft. com/learning/ booksurvey Further Filtering Ideas 49 Distinct Aggre Nested Aggregates Ranking Functions 57 Supported Windowing Elemer 58 ROW NUMBER 58 NILE .63 RANK and dENse rank 66 Distribution functions 68 Supported Windowing Elements 68 Rank distribution functions 68 Inverse Distribution Functions 71 Offset functions 74 Supported Windowing Elements 74 LAG and lead 74 FIRST VALUE, LAST VALUE, and Nth value 76 S ummary 79 Chapter 3 Ordered Set Functions 81 Hypothetical Set Functions RANK 82 DENSE RANK 84 PERCENT RANK 85 CUME DIST 86 General Solution 87 Inverse distribution functions Offset Functions 94 String concatenate 98 Summa 100

...展开详情
试读 127P Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions
立即下载
限时抽奖 低至0.43元/次
身份认证后 购VIP低至7折
一个资源只可评论一次,评论内容不能少于5个字
您会向同学/朋友/同事推荐我们的CSDN下载吗?
谢谢参与!您的真实评价是我们改进的动力~
  • 至尊王者

关注 私信
上传资源赚钱or赚积分
最新推荐
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions 43积分/C币 立即下载
1/127
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第1页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第2页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第3页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第4页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第5页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第6页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第7页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第8页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第9页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第10页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第11页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第12页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第13页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第14页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第15页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第16页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第17页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第18页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第19页
Microsoft.SQL.Server.2012.High-Performance.T-SQL.Using.Window.Functions第20页

试读结束, 可继续阅读

43积分/C币 立即下载