Trjtdtk

Does the reader need to like the PoV character?

Is there a RAID 0 Equivalent for RAM?

How could a planet have erratic days?

Is there any evidence that Cleopatra and Caesarion considered fleeing to India to escape the Romans?

Does Doodling or Improvising on the Piano Have Any Benefits?

How to convince somebody that he is fit for something else, but not this job?

Circuit Analysis: Obtaining Close Loop OP - AMP Transfer function

What kind of floor tile is this?

Microchip documentation does not label CAN buss pins on micro controller pinout diagram

What are some good ways to treat frozen vegetables such that they behave like fresh vegetables when stir frying them?

Is this toilet slogan correct usage of the English language?

In a multiple cat home, how many litter boxes should you have?

Make a Bowl of Alphabet Soup

Can I cause damage to electrical appliances by unplugging them when they are turned on?

Why is the Sun approximated as a black body at ~ 5800 K?

Is it ethical to recieve stipend after publishing enough papers?

C++ copy constructor called at return

Review your own paper in Mathematics

What is the English pronunciation of "pain au chocolat"?

Find the next value of this number series

Which was the first story featuring espers?

Permission on Database

Non-trope happy ending?

Multiplicative persistence

Filtering unique row values in SQL, Advanced

Airline Fares - What analysis should be used to detect competitive price-setting behavior and price correlations?Looking for smallest set of rows that form a natural key in a data setTools to perform SQL analytics on 350TB of csv dataGathering the number of Google results from a large amount of searches.Spark SQL Pivot CrossTab functionalitySQL Server and skip first n rowsMost Efficient Post Processing with Python and Pandasdo the results change if you remove duplicate rows and you sum their weights?Data type detection in TableauWhat kind of plot will be helpful for total count group data ( data grouped by month and year )?

0

1

$begingroup$

My data looks like this: Number(String), Number2(String), TransactionType(String), Cost(Integer)

For number 1, Cost 10 and -10 cancel out so the remaining cost is 100

For number 2, Cost 50 and -50 cancel out, Cost 87 and -87 cancel out

For number 3, Cost remains 274

For number 4, Cost 316 and -316 cancel out, 313 remains as the cost

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-mining dataset data-cleaning sql text-filter

share|improve this question

edited 2 days ago

FirstSlack

asked 2 days ago

FirstSlackFirstSlack

815

$endgroup$

add a comment | 

0

1

$begingroup$

My data looks like this: Number(String), Number2(String), TransactionType(String), Cost(Integer)

For number 1, Cost 10 and -10 cancel out so the remaining cost is 100

For number 2, Cost 50 and -50 cancel out, Cost 87 and -87 cancel out

For number 3, Cost remains 274

For number 4, Cost 316 and -316 cancel out, 313 remains as the cost

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-mining dataset data-cleaning sql text-filter

share|improve this question

edited 2 days ago

FirstSlack

asked 2 days ago

FirstSlackFirstSlack

815

$endgroup$

add a comment | 

$begingroup$

My data looks like this: Number(String), Number2(String), TransactionType(String), Cost(Integer)

For number 1, Cost 10 and -10 cancel out so the remaining cost is 100

For number 2, Cost 50 and -50 cancel out, Cost 87 and -87 cancel out

For number 3, Cost remains 274

For number 4, Cost 316 and -316 cancel out, 313 remains as the cost

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-mining dataset data-cleaning sql text-filter

share|improve this question

edited 2 days ago

FirstSlack

asked 2 days ago

FirstSlackFirstSlack

815

$endgroup$

share|improve this question

edited 2 days ago

FirstSlack

asked 2 days ago

FirstSlackFirstSlack

815

share|improve this question

edited 2 days ago

FirstSlack

asked 2 days ago

FirstSlackFirstSlack

815

asked 2 days ago

FirstSlackFirstSlack

815

asked 2 days ago

FirstSlackFirstSlack

815