I'm afraid you will have to execute the SQL statement undoing it. Of you don't know the previous values, you're out of luck.
Then a backup is your best friend.
Am 10. August 2023 11:02:26 MESZ schrieb Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>:
>Hi friends
>
>I was given a query to update the record in table A with where clause. But
>I executed it in production mistakenly without where clause so it updated
>incorrectly for all rows.
>
>How do I resolve this?