YouTube on MSN

How PostgreSQL functions turn messy data into useful results

This PostgreSQL tutorial demonstrates practical ways to clean, transform, and analyze database information using built-in string and date functions. Examples show how text can be converted to ...
learn

SELECT - GROUP BY clause (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric A ...
GitHub

substring-transact-sql.md

[!INCLUDE [sql-asdb-asdbmi-asa-fabricse-fabricdw-fabricsqldb](../../includes/applies-to-version/sql-asdb-asdbmi-asa-fabricse-fabricdw-fabricsqldb.md)] Returns part of ...
letsdatascience

SQL Window Functions Interview Questions: The Complete Guide

Master every SQL window function pattern tested in data science interviews. 14 worked problems covering ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, running totals, NTILE, and complex multi-window queries ...
bilibili

SQL 字符串裁剪神器：SUBSTRING() 3分钟教你提取关键数据！

简介： 数据库里一堆长字符串，只想取中间的身份证号、手机号或日期怎么办？ 别再手动导 Excel 了，一个 SUBSTRING() 函数全搞定！ 本集重点： 三个参数：str（目标）、pos（从哪开始）、len ...
habr

SQL Window Functions in Simple Terms with Examples

I want to note right away that this article is written exclusively for people who are just starting their journey in learning SQL and window functions. It may not cover complex applications of ...
cloud

Announcing BigQuery-managed AI functions for better SQL

For decades, SQL has been the universal language for data analysis, offering access to analytics on structured data. Large Language Models (LLMs) like Gemini now provide a path to get nuanced insights ...
GitHub

From SQL to SPL：Substring from a column of strings

105009400068600 WNr1.4112 Inox Rund 8.00 mm nach EN 10088-3 + A+C+SL, gesch 105009400068700 WNr1.4301 Inox Rund 36.00 mm nach EN 10088-3, geschliffen, T 105009400068800 WNr1.4104 Inox Rund 25.00 mm ...
bilibili

鲸析SQL刷题挑战 DAY 5：substring细节

SUBSTRING(str, start [, length]) str：表示要进行提取操作的原始字符串。 start：指定开始提取的位置。位置从 1 开始计数，如果 start 为正数，则从字符串的开头开始计数；如果 start 为负数，则从 ...
PopSugar

I Took 100+ Lab Tests Through Function Health — Here's What I Learned

As a person with a chronic illness, I'm no stranger to bloodwork. I used to pore over my lab results, googling the various meanings, and trying not to panic when a test fell out of range. Function ...
KDnuggets

7 Advanced SQL Techniques for Data Manipulation in Data Science

SQL is one of the most used tools in data science for data manipulation. No wonder since SQL was created to query and manipulate data in databases. Because of its purpose, it offers a wide range of ...