Search
 
SCRIPT & CODE EXAMPLE
 

SQL

select only unique values from and to current table

INSERT INTO Table2(Id) SELECT DISTINCT Id FROM Table1 WHERE Id NOT IN(SELECT Id FROM Table2);
Comment

PREVIOUS NEXT
Code Example
Sql :: sql add calculated column 
Sql :: how to select multiple columns from different tables in mysql 
Sql :: get month sql 
Sql :: disable trigger sql server 
Sql :: get only one row in mysql 
Sql :: delete table sqlite 
Sql :: what is unique key in sql 
Sql :: select count distinct multiple columns sql server 
Sql :: sql rownum 
Sql :: add sqlite3 in lumen 
Sql :: sql use with to get value counts and percentages 
Sql :: sqlyog clear cache query 
Sql :: oracle list chain steps 
Sql :: how to do an average on a count sql 
Sql :: case vhdl 
Sql :: mysql range of dates overlap 
Sql :: show sql property syntax for jpa. 
Sql :: java sql connection close 
Sql :: sql track modification 
Sql :: postgresql array to rows 
Sql :: SQL/delete 
Sql :: oracle logfile switch 
Sql :: mariadb used space 
Sql :: automate mysql cli query 
Sql :: mysql in clausule string array 
Sql :: oracle cache matching 
Sql :: sqlcmd 
Sql :: trigger in mysql 
Sql :: cast in sql server 
Sql :: mac docker mysql 
ADD CONTENT
Topic
Content
Source link
Name
6+7 =