What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-03-05 12:00:02
difference between left join and left outer join in postgresql
-- LEFT OUTER JOIN is equivalent to LEFT JOIN -- b.VALUE1 is null when ID not in table2 (idem for c.VALUE1 in table3) SELECT a.ID, a.NAME, b.VALUE1, c.VALUE1 FROM table1 a LEFT OUTER JOIN table2 b ON a.ID = b.ID LEFT OUTER JOIN table3 c ON a.ID = c.I... Add solution -
SQL 2022-03-01 11:15:16
open transactions sqlskills
SELECT [s_tst].[session_id], [s_es].[login_name] AS [Login Name], DB_NAME (s_tdt.database_id) AS [Database], [s_tdt].[database_transaction_begin_time] AS [Begi... Add solution -
SQL 2022-02-26 21:15:24
oracle sql select from multiple tables
-- With JOIN -- No row if id does not exist in t2 SELECT t1.name, t2.salary FROM t1 JOIN t2 on t1.id = t2.id; -- A row with a NULL salary is returned if id does not exist in t2 SELECT t1.name, t2.salary FROM t1 LEFT OUTER JOIN t2 on t1.id = t2.id; -- Wit... Add solution -
SQL 2022-02-06 11:20:10
sql left join 2 tables
-- LEFT OUTER JOIN is equivalent to LEFT JOIN -- b.VALUE1 is null when ID not in table2 (idem for c.VALUE1 in table3) SELECT a.ID, a.NAME, b.VALUE1, c.VALUE1 FROM table1 a LEFT OUTER JOIN table2 b ON a.ID = b.ID LEFT OUTER JOIN table3 c ON a.ID = c.I... Add solution -
SQL 2022-01-31 22:51:47
left join in sql with 3 tables
-- LEFT OUTER JOIN is equivalent to LEFT JOIN -- b.VALUE1 is null when ID not in table2 (idem for c.VALUE1 in table3) SELECT a.ID, a.NAME, b.VALUE1, c.VALUE1 FROM table1 a LEFT OUTER JOIN table2 b ON a.ID = b.ID LEFT OUTER JOIN table3 c ON a.ID = c.I... Add solution -
SQL 2022-01-26 05:10:16
sql values not in another table
-- Find missing t1 values in t2 (based on 'id' field) SELECT * FROM t1 WHERE t1.id NOT IN (SELECT id FROM t2); -- or SELECT * FROM t1 WHERE NOT exists ( SELECT NULL FROM t2 WHERE t2.id = t1.id ); -- or SELECT t1.* FROM t1 LEFT OUTER JOIN t2 ON t2.id =... Add solution -
SQL 2021-11-22 04:39:12
insert into in DBT prehook
{%- macro profile_schema(table_schema) -%} {{ config(schema='profiles') }} {% set not_null_profile_threshold_pct = ".9" %} {% set unique_profile_threshold_pct = ".9" %} {% set tables = dbt_utils.get_relations_by_prefix(table_schema,... Add solution -
SQL 2021-11-22 02:58:12
Update All tables COLLATE DATABASE_DEFAULT
DECLARE @collate nvarchar(100); DECLARE @table nvarchar(255); DECLARE @column_name nvarchar(255); DECLARE @column_id int; DECLARE @data_type nvarchar(255); DECLARE @max_length int; DECLARE @row_id int; DECLARE @sql nvarchar(max); DECLARE @sql_column nvarc... Add solution -
SQL 2021-11-15 03:33:07
how much space does sql server take per row
SELECT TableName = t.NAME, SchemaName = s.Name, [RowCount] = p.rows, TotalSpaceMB = CONVERT(DECIMAL(18,2), SUM(a.total_pages) * 8 / 1024.0), UsedSpaceMB = CONVERT(DECIMAL(18,2), SUM(a.used_pages) * 8 / 1024.0), UnusedSpaceMB = CO... Add solution -
SQL 2021-11-07 07:35:21
left join vs left outer join mysql
-- LEFT OUTER JOIN is equivalent to LEFT JOIN -- b.VALUE1 is null when ID not in table2 (idem for c.VALUE1 in table3) SELECT a.ID, a.NAME, b.VALUE1, c.VALUE1 FROM table1 a LEFT OUTER JOIN table2 b ON a.ID = b.ID LEFT OUTER JOIN table3 c ON a.ID = c.I... Add solution