What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-10-07 16:29:03
sql check date is null
SELECT * FROM yourtable WHERE yourdatecolumn IS NULL Add solution -
Java 2021-09-29 23:47:05
how do you implement api
My PROCESS TO IMPLEMENT API First of all 1. Checking API Contract An API is essentially a contract between the client and the server or between two applications. Before any implementation test can begin, it is important to make sure that the contract is c... Add solution -
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-29 06:36:02
mysql find missing values
-- 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