I have forumal in my crystal but would like to do it in sql

[sonny1974]

i have oracle 9i and crystal xi

this formula works in crystal

if ({Command.RANK}= 3 and previous ({Command.RANK})=2 ) and ({Command.QTY} = {Command.QTY}
and {Command.TRAN_CODE} = '28') or
({Command.RANK}= 3 and previous({Command.RANK})=2 and {Command.TRAN_CODE} <> previous({Command.TRAN_CODE}))then 1

but it wont work in my command statement , when i do a case in sql
can you help me on the coding so it works in my command

 

[sonny1974]

i heard there is a lead or lag in oracle, would that work here?

 

[sonny1974]

would i do a lead ?or lag?
choose? decode?