Expert T-SQL window functions in SQL Server 2019 : the hidden secret to fast analytic and reporting queries /: the hidden secret to fast analytic and reporting queries. ([2019])

• Record Type: Book
• Further Information: Note: Kathi Kellenberger, Clayton Groom, Ed Pollack.
• Authors: Kellenberger, Kathi; Groom, Clayton; Pollack, Ed
• Contents: 1. Looking through the Window -- 2. Discovering Ranking Functions.-3. Summarizing with Window Aggregates -- 4. Calculating Running and Moving Aggregates -- 5. Adding Frames to the Window -- 6. Taking a Peek at Another Row -- 7. Understanding Statistical Functions -- 8. Tuning for Better Performance -- 9. Hitting a Home Run with Gaps, Islands, and Streaks -- 10. Time Range Calculations -- 11. Time Trend Calculations.
• Edition: Second edition
• Publisher Details: New York : Apress
• Publication Date: 2019
• Copyright Date: 2019
• Extent: 1 online resource, illustrations
• Subjects: 005.75/6; SQL (Computer program language); Electronic books; Electronic books
• Languages: English
• ISBNs: 9781484251973; 1484251970
• Related ISBNs: 9781484251966
• Notes: Note: Online resource; title from PDF title page (SpringerLink, viewed October 29, 2019).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.