SQL News

Browse SQL updates sorted by latest

Understanding NULL in BigQuery SQL

Understanding NULL in BigQuery SQL

11 months ago

NULL in SQL represents the absence of a value, distinct from an empty string or zero. Key points include: NULL cannot be tested in a list, comparisons like NULL = NULL are not allowed, COUNT(column) excludes NULLs while COUNT(*) includes them, aggregate functions ignore NULLs, ORDER BY places NULLs first by default, and joins do not match NULLs. Handling NULLs can be done using IS NULL, COALESCE, IFNULL/ISNULL, and NULLIF.

Constantin Lungu
Constantin Lungu

Top Creator

Top BigQuery Creator

Constantin Lungu is a Top BigQuery Creator. Part of Swipe Insight Select, a curated list of top creators.

Top BigQuery Creator
Understanding the Difference: WHERE vs HAVING in SQL

Understanding the Difference: WHERE vs HAVING in SQL

1 years ago

In SQL, WHERE and HAVING differ in their application timing. WHERE is used before aggregation, while HAVING is used after. If 'quantity' is filtered in the HAVING clause, it refers to the SUM of quantities per country bucket, not the original 'quantity'. It's suggested to rename the aggregated column (e.g., 'total_quantity') for clarity. The choice between WHERE and HAVING depends on the need for filtering before or after aggregation.

Constantin Lungu
Constantin Lungu

Top Creator

Top BigQuery Creator

Constantin Lungu is a Top BigQuery Creator. Part of Swipe Insight Select, a curated list of top creators.

Top BigQuery Creator
Simplify SQL Queries with the DECLARE Command

Simplify SQL Queries with the DECLARE Command

1 years ago

The DECLARE command in SQL can simplify queries with varying parameters. Instead of repeatedly using a WHERE statement for different time periods, you can declare variables before your query and adjust them for the desired timeframe. For instance, you can assign names to your variables along with their respective data types, such as '@start_date' and '@end_date' storing 'date' data type.

Google Ads Monthly Slides with AI Insights

Google Ads Monthly Slides with AI Insights

Featured

Create professional Google Ads performance reports in Google Slides with AI insights and visualizations. Transform Google Ads data into polished presentations featuring AI-generated insights and custom visuals to impress stakeholders and streamline reporting. Use cases include reducing manual reporting time, presenting insights without design skills, maintaining reporting schedules, identifying trends, and sharing campaign insights for strategic decisions.

Markifact
Markifact

Verified Sponsor

Verified Sponsor

Markifact is a Verified Sponsor. Want to get featured here? Contact us.

Verified Sponsor

FAQs