首页 > 最新文献

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
下一页 尾页
类型
全部 化学•材料 生命科学 医学 物理 工程技术 环境•农林 材料科学 地球科学 法学 管理学 化学 环境科学与生态学 计算机科学 教育学 经济学 农林科学 人文科学 生物学 数学 物理与天体物理 心理学 综合性期刊 其他 工业工程 理学 历史学 农学 文学 信息工程
数据库
全部 ACS Publications Elsevier ieeexplore Springer The Royal Society of Chemistry Wiley
期刊
Expert T-SQL Window Functions in SQL Server 2019
全部 Acc. Chem. Res. ACS Applied Bio Materials ACS Appl. Electron. Mater. ACS Appl. Energy Mater. ACS Appl. Mater. Interfaces ACS Appl. Nano Mater. ACS Appl. Polym. Mater. ACS BIOMATER-SCI ENG ACS Catal. ACS Cent. Sci. ACS Chem. Biol. ACS Chemical Health & Safety ACS Chem. Neurosci. ACS Comb. Sci. ACS Earth Space Chem. ACS Energy Lett. ACS Infect. Dis. ACS Macro Lett. ACS Mater. Lett. ACS Med. Chem. Lett. ACS Nano ACS Omega ACS Photonics ACS Sens. ACS Sustainable Chem. Eng. ACS Synth. Biol. Anal. Chem. BIOCHEMISTRY-US Bioconjugate Chem. BIOMACROMOLECULES Chem. Res. Toxicol. Chem. Rev. Chem. Mater. CRYST GROWTH DES ENERG FUEL Environ. Sci. Technol. Environ. Sci. Technol. Lett. Eur. J. Inorg. Chem. IND ENG CHEM RES Inorg. Chem. J. Agric. Food. Chem. J. Chem. Eng. Data J. Chem. Educ. J. Chem. Inf. Model. J. Chem. Theory Comput. J. Med. Chem. J. Nat. Prod. J PROTEOME RES J. Am. Chem. Soc. LANGMUIR MACROMOLECULES Mol. Pharmaceutics Nano Lett. Org. Lett. ORG PROCESS RES DEV ORGANOMETALLICS J. Org. Chem. J. Phys. Chem. J. Phys. Chem. A J. Phys. Chem. B J. Phys. Chem. C J. Phys. Chem. Lett. Analyst Anal. Methods Biomater. Sci. Catal. Sci. Technol. Chem. Commun. Chem. Soc. Rev. CHEM EDUC RES PRACT CRYSTENGCOMM Dalton Trans. Energy Environ. Sci. ENVIRON SCI-NANO ENVIRON SCI-PROC IMP ENVIRON SCI-WAT RES Faraday Discuss. Food Funct. Green Chem. Inorg. Chem. Front. Integr. Biol. J. Anal. At. Spectrom. J. Mater. Chem. A J. Mater. Chem. B J. Mater. Chem. C Lab Chip Mater. Chem. Front. Mater. Horiz. MEDCHEMCOMM Metallomics Mol. Biosyst. Mol. Syst. Des. Eng. Nanoscale Nanoscale Horiz. Nat. Prod. Rep. New J. Chem. Org. Biomol. Chem. Org. Chem. Front. PHOTOCH PHOTOBIO SCI PCCP Polym. Chem.
﹀
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
0
微信
客服QQ
Book学术公众号 扫码关注我们
反馈
×
意见反馈
请填写您的意见或建议
请填写您的手机或邮箱
×
提示
您的信息不完整，为了账户安全，请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
现在去查看 取消
×
提示
确定
Book学术官方微信
Book学术文献互助
Book学术文献互助群
群 号：481959085
Book学术
文献互助 智能选刊 最新文献 互助须知 联系我们：info@booksci.cn
Book学术提供免费学术资源搜索服务，方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。
Copyright © 2023 Book学术 All rights reserved.
ghs 京公网安备 11010802042870号 京ICP备2023020795号-1