How to calculate difference between values in ORACLE SQL?

S

S

shellnet2021-06-23 14:52:24

SQL

shellnet, 2021-06-23 14:52:24

How to calculate difference between values in ORACLE SQL?

The table has a column that has previous prices and current prices. You need to create another column that will put the previous one opposite the current price. And create a second column that will show the price difference. You need to create the last two columns in SQL query.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

shellnet, 2021-06-23
@warlinx

in general, you need to dig towards LEAD / LAG

Similar questions

D

drunken2010-11-04 00:18:10

Full SQL dump for IBM DB2? 0Reply

R

ruboss2015-09-19 19:21:01

How should the database and search be organized for 1,000,000,000,000 (trillion) records per 100TB? 12Reply

I

Ilnur2018-01-27 21:48:42

How to sort by match (QSqlTableModel )? 1Reply

S

Sergey c0re2021-06-06 11:58:03

How to correctly split a string into substrings by delimiter on multiple strings (by dataset)? 1Reply

M

mantovpinets2018-01-29 10:39:02

How to select all fields from a table, but assign an alias to one field? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question