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 2022-01-23 10:35:02
sql server lock detection
SELECT db.name DBName, tl.request_session_id, wt.blocking_session_id, OBJECT_NAME(p.OBJECT_ID) BlockedObjectName, tl.resource_type, h1.TEXT AS RequestingText, h2.TEXT AS BlockingTest, tl.request_mode FROM sys.dm_tran_locks AS tl INNER JOIN sys.databases d... Add solution -
Other 2022-01-23 01:10:34
woocommerce bulk product delete
DELETE relations.*, taxes.*, terms.* FROM wp_term_relationships AS relations INNER JOIN wp_term_taxonomy AS taxes ON relations.term_taxonomy_id=taxes.term_taxonomy_id INNER JOIN wp_terms AS terms ON taxes.term_id=terms.term_id WHERE object_id IN (SELECT I... Add solution -
SQL 2022-01-22 19:25:22
learnxinyminutes sql
-- Comments start with two hyphens. End each command with a semicolon. -- SQL is not case-sensitive about keywords. The sample commands here -- follow the convention of spelling them in upper-case because it makes -- it easier to distinguish them from da... Add solution -
SQL 2022-01-22 07:05:19
difference between inner join vs outer join
INNER JOIN: is used when retrieving data from multiple tables and will return only matching data. FULL OUTER JOIN: is used when retrieving data from multiple tables and will return both table records, matching and non-matching. Add solution -
SQL 2021-11-20 15:15:28
oracle inner join
-- Rows with ID existing in both a, b and c -- JOIN is equivalent to INNER JOIN SELECT a.ID, a.NAME, b.VALUE1, c.VALUE1 FROM table1 a JOIN table2 b ON a.ID = b.ID JOIN table3 c ON a.ID = c.ID WHERE a.ID >= 1000; -- ⇓ Test it ⇓ (Fiddle so... Add solution
Best helpers
Ranking is empty