SQL query

sharad_shanu · New User Joined: 03 Oct 2006 Posts: 40

Hi all,

I have a DB2 table with following data.

vicky10001 · Active User Joined: 13 Jul 2005 Posts: 136

Select State, sum(Amt1), sum(Amt1) from table name.

dbzTHEdinosauer · Posted: Wed Jun 27, 2012 3:09 pm

have no way to test it,
don't even know if the syntax is correct,
so you are going to have to test it yourself with spufi:

Naish · New User Joined: 07 Dec 2006 Posts: 82 Location: UK

Hello sharad_shanu,

From what I understood from your post you can try on these lines-

dbzTHEdinosauer · Posted: Wed Jun 27, 2012 3:21 pm

though it was difficult to determine,
I believe the TS wants

State totals
state city totals

but we will have to wait.

Nic Clouston · Posted: Wed Jun 27, 2012 5:55 pm

Very difficult especially as after almost 6 years as a member here he has not learned how to use the code tags to display his data in a readable format.

dick scherrer · Posted: Wed Jun 27, 2012 7:08 pm

The data is now coded, but it was "fiddled with" on the original post and so is not properly aligned. . .

d

Santhosh Menon · New User Joined: 19 Jun 2012 Posts: 4 Location: USA

Just a small tweak to the query by Dick Brenholtz ....(again have not run it in SPUFI)

but i think you want the summed up amount for state and individual amounts for city...

select state as place
,sum(amt1) as Amt1
,sum(amt2) as Amt2
from table
Group by STATE
union all
select
,city
,Amt1
,Amt2
from table

If you want summed up amounts for cities too... then add GROUP by CITY for the second query...

dbzTHEdinosauer · Posted: Wed Jul 04, 2012 7:18 am

Menon,
Even though the TS wanted state and city under the same heading,
i ignored his request
for the obvious reason
that it would require knowledge of all the states and cities
to know what is what.
but,
if the TS wants it his way,
he has your way.