Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Asked: June 3, 20222022-06-03T07:29:22+00:00 2022-06-03T07:29:22+00:00

database – Group data in sql like MUI dataGridPro Grouping

[ad_1]

I am currently trying to select data from database using sql to display data on table
which is same as MUIGridPro table grouping feature.

Input Data
Sample Input Data (Products)

Expected Output if group by one column (col3)

Sample Output Data if group by one column (col3)

Expected Output if group by two columns group on (col1 x col2)

Sample Output Data if group by two columns (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

Sample Output Data if group by two columns (col1 x col2 x col3)

and so on.

but after try I got data is:

OutPut

Please suggest any solution in sql

sample code is here:
Sample fiddle code

looking forward to solutions. Thanks!

[ad_2]

Leave an answer

Stats