Increment the Column values dynamicallyHi
I have certain records in the table.In which i have to create one dynamic column by checking with row2 values of a particular column with row1 value of the same column,So if matched writes 1 otherwise 2...
Identifier Name Serivice
1 GPRS Imobile
1 GPRS Mobile
1 GPRS Application
2 Internet Speed Connection
In above example Identifier is dynamically created column,it will start with 1,then it compare the 2 column NAME GPRS=GPRS,so return 1,next is also same it returns 1,Next is also same,it returns same.But in 4 th row of the column differs Internet=GPRS,So mismatch occured,then identifier should be 2 like that we compare and increment the identifier column..Ho it is possible