|
You are here |
pbidax.wordpress.com | ||
| | | | |
www.kdnuggets.com
|
|
| | | | | Learn the generic scenarios and techniques of grouping and aggregating data, partitioning and ranking data in SQL, which will be very helpful in reporting requirements. | |
| | | | |
modern-sql.com
|
|
| | | | | LISTAGG is the new SQL standard version of GROUP_CONCAT or STRING_AGG. LISTAGG supports DISTINCT and provides an ON OVERFLOW clause to control the behavior when exceeding the maximum string length. | |
| | | | |
sqlserverfast.com
|
|
| | | | | I skipped the last two T-SQL Tuesdays. But this month, I will participate again. The monthly blog party is once more hosted by Steve Jones. His chosen topic is: Window Functions. In his invitation, Steve specifically asks for examples where Window functions provided a neat solution to a real world problem. Well, sorry Steve, but... | |
| | | | |
sqlatspeed.com
|
|
| | | T-SQL Tuesday is a monthly blog party for the SQL Server community. It is the brainchild of Adam Machanic (b|t) and I am thankful for the opportunity to host this month's edition. The concept is straightforward - each month a blog hosts the party and everybody who wants to contribute can write a post about... | ||