|
|
|
Junior Member
 
Group: Forum Members
Last Login: 6/18/2007 5:02:00 PM
Posts: 18,
Visits: 1
|
|
Hi All,
I am trying to verify a table group by say ss_id, and say it returns 10 rows (same ss_id). Now I am trying to verify whether 10th row value > 9th row, 9th row > 8th row ...
I need some feedback on way of resolving the problem.
with regards,
rlaskar
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 8/20/2008 5:30:17 AM
Posts: 10,
Visits: 5
|
|
Hi,
Look for the "PREV_VALUE" & "RESULT" logic in below query.
SEL
SS_ID,
CURR_VALUE,
(SUM(CURR_VALUE)OVER(ROWS 1 PRECEDING) - CURR_VALUE) "PREV_VALUE" ,
(CASE WHEN CURR_VALUE > PREV_VALUE THEN 'TRUE'
WHEN CURR_VALUE = PREV_VALUE THEN 'EQUAL'
ELSE 'FALSE'
END) "RESULT"
FROM(
SEL
SS_ID,
SUM(X) "CURR_VALUE"
FROM XYZ
GROUP BY 1
)A
Is this solution right for your requirement?
|
|
|
|