-
Complex sql query
I have a table which consist of four fields.
-----------------------
FieldA | FieldB|FieldC|FieldD
-----------------------
1 |test 1|5 |d
1 |test 2|6 |f
1 |test 3|0 |w
2 |test 3|5 |r
2 |test 2|5 |y
2 |test 1|5 |e
How do I display the data using complex sql query if possible or using excel pivot to show the following:
FieldA | Sum of Field C for same A value |test1|test2|test3|
----------------------------------------------------------
1 |5+6+0 |d |f |w
2 |5+5+5 |r |y |e
I may use group by FieldA to do the sum. But the later part where each of the rows of FieldB changes to columns ..seems struck me..
Thanks.
Regards
Alucard
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|