Expert T-SQL Window Functions in SQL Server 2019最新文献

筛选
英文 中文
Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries SQL Server 2019中的专家T-SQL窗口函数:快速分析和报表查询的隐藏秘密
Expert T-SQL Window Functions in SQL Server 2019 Pub Date : 2019-10-21 DOI: 10.1007/978-1-4842-5197-3
K. Kellenberger, Clayton Groom, Edward Pollack
{"title":"Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries","authors":"K. Kellenberger, Clayton Groom, Edward Pollack","doi":"10.1007/978-1-4842-5197-3","DOIUrl":"https://doi.org/10.1007/978-1-4842-5197-3","url":null,"abstract":"","PeriodicalId":115255,"journal":{"name":"Expert T-SQL Window Functions in SQL Server 2019","volume":"7 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2019-10-21","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"115312042","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 0
Looking Through the Window 透过窗户看
Expert T-SQL Window Functions in SQL Server 2019 Pub Date : 1900-01-01 DOI: 10.1007/978-1-4842-1103-8_1
K. Kellenberger, Clayton Groom
{"title":"Looking Through the Window","authors":"K. Kellenberger, Clayton Groom","doi":"10.1007/978-1-4842-1103-8_1","DOIUrl":"https://doi.org/10.1007/978-1-4842-1103-8_1","url":null,"abstract":"","PeriodicalId":115255,"journal":{"name":"Expert T-SQL Window Functions in SQL Server 2019","volume":"19 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1900-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"121167097","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 0
Time Range Calculations 时间范围计算
Expert T-SQL Window Functions in SQL Server 2019 Pub Date : 1900-01-01 DOI: 10.1007/978-1-4842-5197-3_10
K. Kellenberger, Clayton Groom, Edward Pollack
{"title":"Time Range Calculations","authors":"K. Kellenberger, Clayton Groom, Edward Pollack","doi":"10.1007/978-1-4842-5197-3_10","DOIUrl":"https://doi.org/10.1007/978-1-4842-5197-3_10","url":null,"abstract":"","PeriodicalId":115255,"journal":{"name":"Expert T-SQL Window Functions in SQL Server 2019","volume":"79 1 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1900-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"129762217","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 0
Adding Frames to the Window 向窗口添加框架
Expert T-SQL Window Functions in SQL Server 2019 Pub Date : 1900-01-01 DOI: 10.1007/978-1-4842-5197-3_5
K. Kellenberger, Clayton Groom, Edward Pollack
{"title":"Adding Frames to the Window","authors":"K. Kellenberger, Clayton Groom, Edward Pollack","doi":"10.1007/978-1-4842-5197-3_5","DOIUrl":"https://doi.org/10.1007/978-1-4842-5197-3_5","url":null,"abstract":"","PeriodicalId":115255,"journal":{"name":"Expert T-SQL Window Functions in SQL Server 2019","volume":"86 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1900-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"134159649","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 0
Taking a Peek at Another Row 看一眼《另一行》
Expert T-SQL Window Functions in SQL Server 2019 Pub Date : 1900-01-01 DOI: 10.1007/978-1-4842-1103-8_7
K. Kellenberger, Clayton Groom
{"title":"Taking a Peek at Another Row","authors":"K. Kellenberger, Clayton Groom","doi":"10.1007/978-1-4842-1103-8_7","DOIUrl":"https://doi.org/10.1007/978-1-4842-1103-8_7","url":null,"abstract":"","PeriodicalId":115255,"journal":{"name":"Expert T-SQL Window Functions in SQL Server 2019","volume":"1 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1900-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"116932985","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 0
Hitting a Home Run with Gaps, Islands, and Streaks 打一个全垒打与空白,岛屿,和连胜
Expert T-SQL Window Functions in SQL Server 2019 Pub Date : 1900-01-01 DOI: 10.1007/978-1-4842-5197-3_9
K. Kellenberger, Clayton Groom, Edward Pollack
{"title":"Hitting a Home Run with Gaps, Islands, and Streaks","authors":"K. Kellenberger, Clayton Groom, Edward Pollack","doi":"10.1007/978-1-4842-5197-3_9","DOIUrl":"https://doi.org/10.1007/978-1-4842-5197-3_9","url":null,"abstract":"","PeriodicalId":115255,"journal":{"name":"Expert T-SQL Window Functions in SQL Server 2019","volume":"55 3 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1900-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"117315909","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 0
Summarizing with Window Aggregates 使用窗口聚合进行汇总
Expert T-SQL Window Functions in SQL Server 2019 Pub Date : 1900-01-01 DOI: 10.1007/978-1-4842-1103-8_3
K. Kellenberger, Clayton Groom
{"title":"Summarizing with Window Aggregates","authors":"K. Kellenberger, Clayton Groom","doi":"10.1007/978-1-4842-1103-8_3","DOIUrl":"https://doi.org/10.1007/978-1-4842-1103-8_3","url":null,"abstract":"","PeriodicalId":115255,"journal":{"name":"Expert T-SQL Window Functions in SQL Server 2019","volume":"299 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1900-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"116455490","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 0
Time Trend Calculations 时间趋势计算
Expert T-SQL Window Functions in SQL Server 2019 Pub Date : 1900-01-01 DOI: 10.1007/978-1-4842-5197-3_11
K. Kellenberger, Clayton Groom, Edward Pollack
{"title":"Time Trend Calculations","authors":"K. Kellenberger, Clayton Groom, Edward Pollack","doi":"10.1007/978-1-4842-5197-3_11","DOIUrl":"https://doi.org/10.1007/978-1-4842-5197-3_11","url":null,"abstract":"","PeriodicalId":115255,"journal":{"name":"Expert T-SQL Window Functions in SQL Server 2019","volume":"23 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1900-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"129330464","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 0
Calculating Running and Moving Aggregates 计算运行和移动聚合
Expert T-SQL Window Functions in SQL Server 2019 Pub Date : 1900-01-01 DOI: 10.1007/978-1-4842-1103-8_5
K. Kellenberger, Clayton Groom
{"title":"Calculating Running and Moving Aggregates","authors":"K. Kellenberger, Clayton Groom","doi":"10.1007/978-1-4842-1103-8_5","DOIUrl":"https://doi.org/10.1007/978-1-4842-1103-8_5","url":null,"abstract":"","PeriodicalId":115255,"journal":{"name":"Expert T-SQL Window Functions in SQL Server 2019","volume":"17 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1900-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"134341647","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 0
Discovering Ranking Functions 发现排行函数
Expert T-SQL Window Functions in SQL Server 2019 Pub Date : 1900-01-01 DOI: 10.1007/978-1-4842-1103-8_2
K. Kellenberger, Clayton Groom
{"title":"Discovering Ranking Functions","authors":"K. Kellenberger, Clayton Groom","doi":"10.1007/978-1-4842-1103-8_2","DOIUrl":"https://doi.org/10.1007/978-1-4842-1103-8_2","url":null,"abstract":"","PeriodicalId":115255,"journal":{"name":"Expert T-SQL Window Functions in SQL Server 2019","volume":"6 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"1900-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"114236188","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 0
0
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
确定
请完成安全验证×
相关产品
×
本文献相关产品
联系我们:info@booksci.cn Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术官方微信