how to get the following result

Question

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 399289 More actions · Answer 1

I'm confused, based on the data provided, how does RAJ get a value of 800? What is it that you're trying to do?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

er.nawazish 37834 Newbie Points: 2 More actions · Answer 2

in table 2 for all the same state id ,sales amout should be summed up

Grant Fritchey SSC Guru Points: 399289 More actions · Answer 3

Oh, I think I see. The formatting was WAY off there.

Take a look at the command GROUP BY. You can perform aggregate operations on your data using that. SUM() would be the first aggregation you'd want.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt