What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-01-29 08:20:11
update multiple columns in sql
-- Oracle UPDATE table2 t2 SET (VALUE1, VALUE2) = (SELECT COL1 AS VALUE1, COL1 AS VALUE2 FROM table1 t1 WHERE t1.ID = t2.ID); -- SQL Server UPDATE table2 t2 SET t2.VALUE1 = t1.COL1, t2.VALUE2 = t1.COL2 FROM table1 t1 INNER JOIN t2 ON t1.ID = ... Add solution -
SQL 2021-10-23 14:27:07
joins in sql
JOINING 2 Tables in sql SELECT X.Column_Name , Y.Column_Name2 FROM TABLES1_NAME X INNER JOIN TABLES2_NAME Y ON X.Primary_key = Y.Foreign_key; --FOR EXAMPLE --GET THE FIRST_NAME AND JOB_TITLE --USE EMPLOYEES AND JOBS TABLE --THE RELATIONSHIP IS JOB_ID ... Add solution
Best helpers
Ranking is empty