Tag: sql

MySQL's LATERAL derived tables solve the top-N-per-group problem cleanly. Here is how PHP and Laravel developers use them with joinLateral and raw SQL.

MySQL window functions let the database do ranking, running totals, and row comparisons that most PHP devs still handle in application code.

Recursive CTEs in MySQL let you query trees, org charts, and nested categories in a single query. Here's how to use them effectively with PHP.