We have moved to www.dataGenX.net, Keep Learning with us.

Thursday, October 02, 2014

How to UPDATE row based on a row in same table

How you will update the Data of a table based on same table ??

update Table_DUMMY T1 
set COL_UPDT = (select T2.COL_FROM from Table_DUMMY T2 where T1.KEY=T2.KEY )  

Like the Facebook Page & join Group

For WHATSAPP group , drop a msg to 91-88-00-906098

No comments :

Post a Comment