Explore the difficulties associated with pivoting data in SQL compared to spreadsheets.
Also find me here:
Baeldung Author
Hannah Igboke
A Data Scientist, analyst and technical writer. Interested in working with NASA and a dedicated fan of Sudoku puzzles, chess games, GOT and Harry Potter book series.
Here's what I've written (so far):
Baeldung on SQL
- All
- SQL Queries (3)
- Databases (2)
- Database Concepts (2)
How to Configure Time Zone Settings in MySQL?
Filed under Databases
Learn how MySQL handles time zones.
Introduction to Apache Doris
Filed under Databases
A quick intro to Apache Doris.
Rebuilding All Indexes in a SQL Server Database
Filed under Database Concepts
Learn how to rebuild a fragmented index in SQL Server.
Generate SQL Insert Script From Excel Worksheet
Filed under SQL Queries
Explore methods for generating SQL INSERT scripts from an Excel worksheet and best practices for ensuring a smooth execution process.
The Relationship Between Primary Keys and Clustered Indexes
Filed under Database Concepts
Discover clustered indexes, as well as their relation to and differences from primary keys.
Subquery vs. Correlated Subquery: What’s the Difference?
Filed under SQL Queries
Explore the similarities and distinctions between a subquery and a correlated subquery.