39 How to update data in one table from another table in sql

Рет қаралды 16,927

Күн бұрын

Пікірлер: 23

@ajitkalawade9880 Жыл бұрын

How can we do this if we have duplicates record in on codition column ...here you used customer id which is primary key...but how we do when we have duplicate column values

@learnssis Жыл бұрын

The syntax for update query will be same. If you have duplicate records in the table then the update query will update all records satisfying the update condition.

@buddhikaperera5716 Жыл бұрын

your explanation is wonderful.. this lesson help me very much

@learnssis Жыл бұрын

Thank you Buddhika for your comment.

@pravingaddam8541 5 ай бұрын

@@learnssisI am getting error for same query in SQL developer, ora-00933

@learnssis 5 ай бұрын

@@pravingaddam8541 This query is for MS SQL Server. It seems like you are using Oracle. You can ask chatgpt to convert your query for Oracle.

@pravingaddam8541 5 ай бұрын

@@learnssis yes tried, it's working in Oracle SQL

@exsammy84 Жыл бұрын

How to include a 3rd column after AND statement? Please help

@learnssis Жыл бұрын

Can you please paste your query here and tell us which 3rd column you want to add ? Also do you want to include third column in where clause in update columns ?

@rakeshrajmandala6538 Жыл бұрын

Hi, Can we update the data from tab2 to tab1 when there is no column created in tab1. Can we create a new column simultaneously.

@learnssis Жыл бұрын

In the update query you can't create a new column. update query is used just to update the data. if you want to create a new column then you would need to use the alter query like below alter table Salary Add EmployeeSalary money

@KranthiPasupuleti-u6i 9 ай бұрын

Thnaks a lot ....Keep Rocking ...

@learnssis 9 ай бұрын

Thank you Kranthi.

@laobai3517 3 ай бұрын

can we edit customerID?

@learnssis 3 ай бұрын

You can update any column.

@laobai3517 3 ай бұрын

@@learnssis but what if the colunm's value is also in another table.

@learnssis 3 ай бұрын

@@laobai3517 Then you need to make a join on another column in the table and update the customerID. If required you can join 2 tables based on multiple columns and then you can update customerID.

@laobai3517 3 ай бұрын

@@learnssis perhaps in multiple table and i don't know exact number of the tables,, i solved it because the document exported also can be opened by notepad, so i replaced all customerID with a new value. thank you so much.