Hfrxdjt

Isn't the word "experience" wrongly used in this context?

Why I don't get the wanted width of tcbox?

Asserting that Atheism and Theism are both faith based positions

Do native speakers use "ultima" and "proxima" frequently in spoken English?

"Marked down as someone wanting to sell shares." What does that mean?

What are the rules for concealing thieves' tools (or items in general)?

Is xar preinstalled on macOS?

Does the Shadow Magic sorcerer's Eyes of the Dark feature work on all Darkness spells or just his/her own?

When should a starting writer get his own webpage?

How to find the largest number(s) in a list of elements, possibly non-unique?

Air travel with refrigerated insulin

What will the Frenchman say?

Exit shell with shortcut (not typing exit) that closes session properly

Hackerrank All Women's Codesprint 2019: Name the Product

PTIJ: Why do we make a Lulav holder?

Can other pieces capture a threatening piece and prevent a checkmate?

What is the reasoning behind standardization (dividing by standard deviation)?

Did Nintendo change its mind about 68000 SNES?

Print last inputted byte

Why do I have a large white artefact on the rendered image?

Turning a hard to access nut?

Could any one tell what PN is this Chip? Thanks~

Why didn’t Eve recognize the little cockroach as a living organism?

Do I need an EFI partition for each 18.04 ubuntu I have on my HD?

Filtering unique row values in SQL

How to best accomplish high speed comparison of like data?Data scheduling for recommenderLooking for smallest set of rows that form a natural key in a data setWhat kind of research I can do with my data set?Sql satament sql serverSQL Server and skip first n rowsMost Efficient Post Processing with Python and PandasR - How do I remove a varying number of digits from a date-vectorNeed suggestion on picking fast aggregation framework or solutionMerging dataframes in Pandas is taking a surprisingly long time

0

1

$begingroup$

My data looks like this:

For number "1", Prices "100" and "-100" cancel out so the remaining price is 200

The output I am looking for Looks like this:

How do I do this in SQL?

I have tried "sum(price)" and group by "number", but oracle doesn't let me get results because of other columns

data data-cleaning sql

share|improve this question

edited 27 mins ago

Ethan

576222

asked 2 hours ago

FirstSlackFirstSlack

613

$endgroup$

add a comment | 

0

1

$begingroup$

My data looks like this:

For number "1", Prices "100" and "-100" cancel out so the remaining price is 200

The output I am looking for Looks like this:

How do I do this in SQL?

I have tried "sum(price)" and group by "number", but oracle doesn't let me get results because of other columns

data data-cleaning sql

share|improve this question

edited 27 mins ago

Ethan

576222

asked 2 hours ago

FirstSlackFirstSlack

613

$endgroup$

add a comment | 

$begingroup$

My data looks like this:

For number "1", Prices "100" and "-100" cancel out so the remaining price is 200

The output I am looking for Looks like this:

How do I do this in SQL?

I have tried "sum(price)" and group by "number", but oracle doesn't let me get results because of other columns

data data-cleaning sql

share|improve this question

edited 27 mins ago

Ethan

576222

asked 2 hours ago

FirstSlackFirstSlack

613

$endgroup$

share|improve this question

edited 27 mins ago

Ethan

576222

asked 2 hours ago

FirstSlackFirstSlack

613

share|improve this question

edited 27 mins ago

Ethan

576222

asked 2 hours ago

FirstSlackFirstSlack

613

edited 27 mins ago

Ethan

576222

edited 27 mins ago

Ethan

576222

asked 2 hours ago

FirstSlackFirstSlack

613

asked 2 hours ago

FirstSlackFirstSlack

613