I am currently trying to select data from database using sql to display data on table
which is same as MUIGridPro table grouping feature.
Expected Output if group by one column (col3)
Expected Output if group by two columns group on (col1 x col2)
Expected Output if group by three columns group on (col1 x col2 x col3) no change because table have only 3 columns and one id column
and so on.
but after try I got data is:
Please suggest any solution in sql
sample code is here:
Sample fiddle code
looking forward to solutions. Thanks!