What's the equivalent of SELECT x FROM (SELECT...) ?

ThingEngineer / PHP-MySQLi-Database-Class

Wrapper for a PHP MySQL class, which utilizes MySQLi and prepared statements.

Other

3.28k stars 1.35k forks source link

What's the equivalent of SELECT x FROM (SELECT...) ? #986

Open jalbano opened 2 years ago

jalbano commented 2 years ago

I can't seem to find a way to do nested SELECTs - is it possible? I need to do 2 levels of "group by" which is why (I think) I need to do the nesting. The raw SQL works fine (but don't want to use rawQuery() because I have lots of conditions that tweak the query and manipulating the raw string gets messy.