YouTube on MSN

Exploratory data analysis in MySQL using real layoff data for beginners

Exploratory data analysis in MySQL turns a cleaned company layoffs dataset into practical insights using queries that ...
note

About substr, instr, and trim

These three functions are extremely powerful and can be called the "three sacred treasures" of text (string) data cleansing in SQLite. Once you master how they work, you will be able to perform any ...
note

substr instr trim について

この3つの関数は、SQLiteにおけるテキスト（文字列）データクレンジングの「三種の神器」とも言える非常に強力な関数です。仕組みをマスターすると、どんな複雑な文字列整形も自由自在に ...
learn

MEDIAN (Transact-SQL)

The MEDIAN function returns the exact median, or 50th percentile, of non-NULL numeric values. You can use it as both an aggregate function and a window (analytic) function: Aggregate usage: Returns ...
GitHub

substring-transact-sql.md

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

Generate Embeddings Function and External Model Object Support Are Now Generally Available in Azure SQL

We are excited to announce the General Availability (GA) of AI_GENERATE_EMBEDDINGS and CREATE EXTERNAL MODEL in Azure SQL Database and Azure SQL Managed Instance. These two T-SQL features — CREATE ...
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 ...
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 ...
databricks.com

Introducing Spatial SQL in Databricks: 80+ Functions for High-Performance Geospatial Analytics

Accelerate your scaled geospatial queries with over 80 Spatial SQL functions, now available for public preview. Seamlessly store both planar and geodetic data using native GEOMETRY and GEOGRAPHY data ...
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 ...
blog.csdn

Flink SubString、Betwwen函数反解析

package com.example; import org.apache.calcite.avatica.util.Casing; import org.apache.calcite.avatica.util.Quoting; import org.apache.calcite.sql.*; import org.apache ...