How to update a row with another row if column values are null in SQL

ManojKumar19

Rate me:

5.00/5 (4 votes)

17 Aug 2012CPOL

78.1K

Update row column with another row column in same table SQL only if it is null.

Revisions

Compare	Revision	Minor	Date	Status	Editor
	3 - publicly available	No	17-Aug-12 9:00	Available	Smitha Nishant
Updates in content. 11 changes had been made.
	2	No	17-Aug-12 8:28	Pending	ManojKumar19
Updates in content.
	1	No	17-Aug-12 8:27	Pending	ManojKumar19
Initial creation

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

ManojKumar19

Architect

United States

Manoj Kumar

AWS Certified Solutions Architect (Web development, Serverless, DevOps, Data)
MSSE - Cloud and Mobile Computing, San Jose State University

A wide range of experience in resolving complex business problems.

* Cloud Technologies: EC2, S3, DynamoDB & RDS databases, Lambda serverless architecture, Microservices architecture, API Gateway, Cloud Front CDN, Linux/Windows systems administration, CloudFormation, DevOps, Docker, CICD, Node.js, Python, Java and other open source technologies. Familiarity with OpenStack.
* Web Technologies: HTML5, Node.Js, MEAN Stack, AngularJS, ASP.Net Core, MVC5, CSS3, jQuery, Bootstrap, MongoDB, JavaScript, JSON, AJAX.
* Data: Experience in database architecture, Big Data, Machine Learning, BI, Data Analytics, No-SQL databases, ETL.
* Mobile: IOS/Android app development

He lives with his wife Supriya and daughter Tisya in Bay Area.

How to update a row with another row if column values are null in SQL

Revisions

License

Comments and Discussions