--update query example UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
UPDATE table_name SET column1 = value1, column2 = value2...., columnN = valueN WHERE [condition];
UPDATE YourTable SET Col1 = OtherTable.Col1, Col2 = OtherTable.Col2 FROM ( SELECT ID, Col1, Col2 FROM other_table) AS OtherTable WHERE OtherTable.ID = YourTable.ID
SQL> UPDATE CUSTOMERS SET ADDRESS = 'Pune' WHERE ID = 6;