Hello all,
I am new in this database world and my question is that I want to generate one ERP report for client in this format :
Name Email Subtotal Shipping Total Created at
#71410 103034006@qq.com 162.22 42 204.22 2015-12-11 06:04:21 +0100
#71410 103034006@qq.com 2015-12-11 06:04:21 +0100
#71410 103034006@qq.com 2015-12-11 06:04:21 +0100

There are six columns in which I have to produce my output. I want to show the subtotal which is sum of three products,total which is sum of subtotal and shipping in one single row. I don't want to show subtotal,shipping and total in all the three rows. Pleae help me. Before this ERP report client had asked me to show the output in single row. So by using group concat i was able to show the correct output. But now I have to show report in this format. Please help me in this. I have attached the file. In this format client wants the report. Please help me

With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

Sorry for my late reply. Actually, I am using PHPMyadmin. My tables are all MYSQL tables.I did ask this question on various MYSQL forums but no one replied. I have not received any reply from any MYSQL forums. Please help me in this.

OK very sorry.
I had written following query to produce the previous report which was client asking.In which I had to show the details in one single line. I mean subtotal which is sum of all the products. And Total which is sum of shipping plus subtotal. Now, client asking me to produce the output as shown in the attached csv file in which he still wants subtotal and total in single line but he doesn't want the grouping of names,email. I don't know how to write that code.