python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - pivot

How to summarize by month and return result in column by month

I'm new to Oracle SQL and need help on writing a SQL script to calculate sales total by month, and return result set in total column by month. Thank you. For example, input table: DATE ITEM SALE...
test-img

concatto

sql

oracle

pivot

Votes: 0

Answers: 1

Latest Answer

One option is conditional aggregation: select item, sum(case when to_char(date_column, 'mm') = '01' then sales else 0 end as jan, sum(case when to_char(date_column, 'mm') = '02' then sales else...
test-img

Littlefoot

Is there a possibility to restructure a pivot table?

Access Risk ID User ID SOD05 144 SOD05A 74 SOD06 140 SOD07A 50 SOD08A 30 ... ... SOD77B 30 SOD78 30 SOD78A 30 SOD78B ...
test-img

Max

python

pandas

pivot

Votes: 0

Answers: 1

Latest Answer

Like I suggested in the comment, you can use groupby: print(df.groupby(['Access Risk ID', 'User ID']).sum()) The sum in this example sums the remaining columns (in your case "Executed within the...
test-img

Tranbi

add a an extra row in the outcome

I have a ORACLE sql query that needs to add a header (Only one row) with the name of the columns in the outcome. How could that be achieved? 1-1-2022 08:32:00 xxx1 166 1 04641127 8 1 1-1-2...
test-img

Ezz

sql

string

oracle

pivot

Votes: 0

Answers: 1

Latest Answer

UNION is one option; note that - in that case - both SELECT statements have to share the same number of columns and their datatypes. Something like this: select 'Date' col1, 'dep' col2, 'room' col3, '...
test-img

Littlefoot

Pivot and aggregate 1..n duplicate records Postgres psql

I have a table tbl_action like this: game_id action action_datetime 1 start 2022-04-05T10:30+00 1 attack 2022-04-05T10:45+00 1 defend 2022-04-05T11:30+00 1 attack 2022-04-05T11:45+00 1...
test-img

d3f2

postgresql

pivot

psql

Votes: 0

Answers: 2

Latest Answer

You can try to use subquery with ROW_NUMER window function which help you make row number by game_id, action_name columns, then you can use condition aggregate function for that rn SELECT game_id,...
test-img

D-Shih

Posts

Questions

Blogs

Jobs