OraFAQ Forum: SQL & PL/SQL » compare column value to a column value in next row

Home » SQL & PL/SQL » SQL & PL/SQL » compare column value to a column value in next row (Oracle Database 11g Enterprise Edition Release 11.1.0.7.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

compare column value to a column value in next row [message #641764]

Fri, 21 August 2015 15:37

rkhatiwala
Messages: 178
Registered: April 2007

Senior Member

Hello all,

I want to compare 2 values of same column in same row - like
Quote:

ROW COLUMN COMP_VAL
1 A 0
2 B A
3 C B
4 D C
5 E D

How to get the values in the COMP_VAL columns, in a single SELECT statment, without using LOOP. I've tried rownum, but it doesnt work.

thanks,
rk

Report message to a moderator

Re: compare column value to a column value in next row [message #641765 is a reply to message #641764]

Fri, 21 August 2015 16:51

Solomon Yakobson
Messages: 3312
Registered: January 2010
Location: Connecticut, USA

Senior Member

Use analytic function LAG.

SY.

Report message to a moderator

Re: compare column value to a column value in next row [message #641802 is a reply to message #641765]

Mon, 24 August 2015 08:53

rkhatiwala
Messages: 178
Registered: April 2007

Senior Member

Thanks. I was using the sql in the oracle reports. It seems to be working.

Report message to a moderator

Previous Topic:	Oracle Hierarchical Query max_level/connect_by_is_root
Next Topic:	Table partition

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 03 14:28:54 CDT 2026