I want to update a cloumn in table with respective to condition status(open,app,exp)
1. i want to get max value of one column with the status app,exp
2. and update the max value of column status open,app alone not exp ?
i am confusing with out updating exp record how can i do that ??