Search
 
SCRIPT & CODE EXAMPLE
 

SQL

select only distinct values 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 :: insert data from one database table to another database table in postgresql using pgadmin 
Sql :: mysql trigger 
Sql :: oracle job class 
Sql :: what data type to use for phone number in sql 
Sql :: sql select on string 
Sql :: sql drop all tables 
Sql :: group by max date 
Sql :: sql update multiple tables 
Sql :: sql numeric data type 
Sql :: demmarrer un service mysql teminal cmd 
Sql :: left join in sql oracle 
Sql :: php mysql select current month 
Sql :: openquery join two tables 
Sql :: sql store procedure 
Sql :: trunc sysdate in oracle 
Sql :: cara menampilkan user di mysql terminal 
Sql :: sql delete just one row 
Sql :: MySql Subtract a table from another 
Sql :: tablo silme SQL 
Sql :: sql revert migration 
Sql :: postgresql insert multiple rows 
Sql :: t sql cursor tr 
Sql :: postgres copy table 
Sql :: psql invalid command N 
Sql :: description query in sql 
Sql :: mysql sleep connections 
Sql :: sql round datetime 
Sql :: how use trigger in sql 
Sql :: set up mssql in mac m1 
Sql :: how to close external sql connection in laravel 
ADD CONTENT
Topic
Content
Source link
Name
5+1 =