How group by will work internally when group by using three or more columns in mysql. Also explain the use of temp table table created for the query by the mysql
I need to know about multiple columns of group by will work? how the temp table will be created and used to increase the performance of the query in mysql