2022年6月17日
Get top 1 row of each group
摘要： Get top 1 row of each group 回答1 ;WITH cte AS ( SELECT *, ROW_NUMBER() OVER (PARTITION BY DocumentID ORDER BY DateCreated DESC) AS rn FROM DocumentStat 阅读全文
posted @ 2022-06-17 14:15 ChuckLu 阅读(39) 评论(0) 推荐(0)
Top 3 Tips You Need to Know to Write Faster SQL Views
摘要： Top 3 Tips You Need to Know to Write Faster SQL Views Friend or foe? SQL Server views have been a subject of heated debates when I was in my first yea 阅读全文
posted @ 2022-06-17 12:53 ChuckLu 阅读(31) 评论(0) 推荐(0)