I am updating table’s column values with UPDATE and SELECT statement. But its not working
I am updating PREVIOUS_DAY_CLOSE column which contains DAY_CLOSE-1 values. I am using LAG() function to get PREVIOUS_DAY_CLOSE values. Its working fine. But updating the column with UPDATE and SELECT statement which is showing errors. DAY DAY_OPEN DAY_CLOSE PREVIOUS_DAY_CLOSE 29-05-2024 16879.35 16920.58 28-05-2024 16988.31 17019.88 24-05-2024 16879.35 16920.79 23-05-2024 16996.39 16736.03 I have tried below queries […]
Oracle SQL UPDATE Statement, Needs to Begin with SELECT
I have my update script: