I have a table where I have to check the values between column Value1 and value2. If value1 is less than value2, update the status 'Low' in Status column, if greater then update status to 'High'.
I have tried with this query
UPDATE table
SET Status = If(value1 <= value2) Then 'Low' else 'High'
Please guide to a solution.
Aucun commentaire:
Enregistrer un commentaire