Can anyone please advise me regarding a scenario for which i need to build the solution.
I have a table like below.
ColumnA | ColumnB | ColumnC | DATE
In the program, based upon this condition -
IF DATE > System Date
then run the below query :
SELECT DATE INTO :WS-DATE FROM TABLE
WHERE ColumnA = :some value
ColumnB = :some value
ColumnC = :some value
The issue is, in the table ColumnA, ColumnB and ColumnC values can be same. So sometimes it is having more than 1 same rows and at that time program is getting abended with duplicate rows.
I was thinking to write a cursor and fetch the value one by one but the issue is I have to fetch the value of date for each row and do some functionality if the row is present. I have to do this functionality for each row even if it is duplicate and to reach on this para which is having this query, above mentioned condition (IF DATE > System Date) should be satisfied.
So is there any way to read the duplicated row directly when coming on this query for second or third time ?