Member Avatar for vyzvam
vyzvam 0 Newbie Poster

Goo day all, i need a solution for the following scenario.
I have a table, let's call it "sales" and i want to create a sql that will produce a detailed summary. below is the sample data (image 1)and how i want the end result to look like (image 2)

I have attached the images with this post

Note: Not worry of the result format, I'm only interested in the sql statement that will produce the result.

A solution is greatly appreciated, thanks !!

groupby_table_data.png 3.82 KB groupby_table_sample.png 2.02 KB
  • 1 Contributor
  • 0 Replies
  • 52 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.