Forum Discussion
Help with code
I have this code in oracle if (Income == "NULL") {0} else if (Emplid == Prior(Emplid) && Income != Prior(Income)) {1} else if (Emplid != Prior(Emplid) && Income != "Unreported") {1} else {0} ...
"Does not work" means what in detail? That's really to less on information.
Please post table design as DDL, some sample data as DML statement and the expected result.
Please post table design as DDL, some sample data as DML statement and the expected result.
Thank you olafhelper
Here is an image about what result I need it
| Emplid | Term | IncomeYY | Count_Income |
| 1 | 2213 | Unreported | 0 |
| 1 | 2237 | $35,000 or More | 1 |
| 1 | 2237 | $35,000 or More | 0 |
| 1 | 2243 | Unreported | 0 |
| 1 | 2243 | $35,000 or More | 1 |
| 1 | 2245 | Unreported | 0 |
Here is an image about what result I need itFine,m and what is the source data?
Again, please post table design as DDL, some sample data as DML statement and the expected result.