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

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

《Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions》是Microsoft Press出版的圖書,作者是Itzik Ben-Gan

基本介紹

  • 中文名:Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions 
  • 作者:Itzik Ben-Gan
  • 出版社:Microsoft Press
  • 出版時間:2012年5月1日
  • 頁數:244 頁
  • 裝幀:Paperback
  • ISBN:9780735658363
  • 售價:USD 36.99
內容簡介
Perform efficient database queries with T-SQL window functions Get a detailed look into the practical applications of window functions in Transact-SQL - the database programming language built into Microsoft SQL Server. Led by T-SQL expert Itzik Ben-Gan, you'll learn how to perform calculations against sets of rows in your database - in a flexible, clear, and efficient manner. ...(展開全部) Perform efficient database queries with T-SQL window functions Get a detailed look into the practical applications of window functions in Transact-SQL - the database programming language built into Microsoft SQL Server. Led by T-SQL expert Itzik Ben-Gan, you'll learn how to perform calculations against sets of rows in your database - in a flexible, clear, and efficient manner. Delve into SQL windowing concepts and discover practical uses for various T-SQL window functions. Discover how to: * Apply SQL windowing concepts and window function design * Gain experience with window aggregate, ranking, offset, and distribution functions * Know when to use SQL ordered set functions, such as hypothetical set functions and inverse distribution functions * Optimize window functions in SQL Server 2012 * Use practical examples of T-SQL window functions to address common business tasks

熱門詞條

聯絡我們