What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-09-29 10:56:06
sql find missing values between two tables
-- Returns missing my_table1 ID in my_table2 SELECT DISTINCT t1.* FROM my_table t1 LEFT OUTER JOIN my_table2 t2 ON t1.ID = t2.ID WHERE t2.ID is null; -- Or: SELECT t1.* FROM my_table1 t1 WHERE NOT EXISTS (SELECT ID FROM my_table2 t2 WHERE t2.ID = t1.... Add solution -
SQL 2021-09-25 22:34:04
correlated subqueries in microsoft sql server
USE AdventureWorks2016; GO SELECT DISTINCT c.LastName, c.FirstName, e.BusinessEntityID FROM Person.Person AS c JOIN HumanResources.Employee AS e ON e.BusinessEntityID = c.BusinessEntityID WHERE 5000.00 IN (SELECT Bonus FROM Sales.SalesPerson sp ... Add solution -
SQL 2021-09-13 02:04:02
what is distinct in sql
SELECT DISTINCT column1, column2, ... FROM table_name; Add solution -
SQL 2021-08-31 13:41:02
distinct in sql server
SELECT DISTINCT column1, column2, ... FROM table_name; Add solution