Intermediate SQL tutorial demonstrating REGEXP for advanced filtering, IF & CASE statements to create categories, SUBQUERIES ...

Introduction"I want to list customers who haven't ordered, but I get zero results," or "The count doesn't match when I ...

Customer stories Events & webinars Ebooks & reports Business insights GitHub Skills ...

Hard SQL interview questions test the advanced problem solving skills expected in many medium and senior level data analyst ...

The theme for this time is SQL "execution plans."Execution plans are one of the technologies you absolutely must understand when considering database performance.However, this content might also be a ...

Search for vectors similar to a given query vectors using an approximate nearest neighbors vector search algorithm. To learn more about how vector indexing and vector search works, and the differences ...

Databricks SQL version 2026.38 is rolling out to the Current channel. See features in 2026.38. The parse_sql function parses a SQL statement and returns structured JSON that contains statement ...

NEAREST BY is a new SQL join for batch vector search: for every query row, find the k nearest rows by vector similarity or distance — exact or approximate. A fused Photon operator with a custom ...

Most revenue reporting problems are not hard SQL. They’re the same handful of problems showing up in different tables: gaps in the calendar, days cut at the wrong midnight, duplicate records, totals ...