Posts Tagged ‘group by’

limit left join

Recently we had to pull a single date from a table of dates during a left join. In fact, we needed the most recent date that matched a particular id. We quickly figured out that a left join does not allow for the use of limits in our case. The Dilemma We did mean in […]

Group By

Mysql is a very nice database. Just like php its extreamly forgiving. Anyone with experience with RDBMS setups will know exactly what we mean. For this article, we will be discussing the “Group By” argument and how mysql makes really good guesses. Moreover, we will be discussing what happens when mysql doesn’t make that guess […]