Search
 
SCRIPT & CODE EXAMPLE
 

SQL

select only distinct values from another table

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

PREVIOUS NEXT
Code Example
Sql :: select only distinct values another table 
Sql :: SQL IS NULL With COUNT() 
Sql :: isnull in sqlite 
Sql :: pgadmin postgres ERROR: database is being accessed by other users 
Sql :: mysql count 
Sql :: delete insert record in sql server 
Sql :: sql create cluster index 
Sql :: sqlite clear shell 
Sql :: not keyword in sql 
Sql :: oracle ora-00054 how to unlock 
Sql :: SQL isnumeric DB2 
Sql :: mysql custom sort order 
Sql :: mql5 list all available symbols 
Sql :: what is delete in sql 
Sql :: calculer pourcentage mysql 
Sql :: reset counter postgres 
Sql :: psql concat string and int 
Sql :: getting customers with no orders sql 
Sql :: create directory in sql server 
Sql :: homebrew mysql service not starting 
Sql :: docker use mysql 
Sql :: postrgesql concat 2 columns divided by ; 
Sql :: how convert into in in sql query 
Sql :: sql alter table 
Sql :: above average salary in sql 
Sql :: SQL Switch Databases 
Sql :: sql is null and is not null 
Sql :: oracle tablespace autoextend 
Sql :: add role to group postgres 
Sql :: oracle select 
ADD CONTENT
Topic
Content
Source link
Name
4+7 =