SQL Language (MOSC)

MOSC Banner

Substract Value from Previous Row Grouped by specific Column

edited Nov 14, 2016 4:22PM in SQL Language (MOSC) 2 commentsAnswered ✓

Hello Gurus,

Using Oracle 11 and having below data and

CREATE TABLE TOTAL_JOB (

  CODE VARCHAR2(10),

  JOB VARCHAR2(10),

  JOBCODE VARCHAR2(10),

  TOTAL number(10),

  SUBSTRACT number(10));

INSERT INTO TOTAL_JOB VALUES ('X1','47113','A1',6812,80);

INSERT INTO TOTAL_JOB VALUES ('X1','47114','A1',6812,100);

INSERT INTO TOTAL_JOB VALUES ('X1','47113','B1',3173,20);

INSERT INTO TOTAL_JOB VALUES ('X1','47114','B1',3173,25);

INSERT INTO TOTAL_JOB VALUES ('X1','47113','C1',0,20);

INSERT INTO TOTAL_JOB VALUES ('X1','47114','C1',0,25);

Using Below Query:

select * from TOTAL_JOB

SELECT TT1.code,

  TT1.job,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center