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

所需积分/C币:10 2018-10-12 10:39:02 16.98MB PDF
16
收藏 收藏
举报

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 www.allitebooks.com 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 www.allitebooks.com To the quartet. O1 www.allitebooks.com www.allitebooks.com 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 www.allitebooks.com www.allitebooks.com 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 Framing 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 www.allitebooks.com 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 www.allitebooks.com

...展开详情
试读 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 10积分/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页

试读结束, 可继续阅读

10积分/C币 立即下载