How to update table with max function and flag should be marked as 'M' only one row.
You will need to use row_number and a CTE to do this
with cte as ( select row_number() over (order by shipment_count desc) as rn, * from test ) update cte set flag = 'm' where rn = 1
15 People are following this question.
How to enable Connection Pooling with Doctrine PHP framework please ?, all the DB connections from the application are NonPooled and hence causing high PREEMPTIVE_OS wait stats. Any advice on it would be greatly appreciated. Thanks