Search
 
SCRIPT & CODE EXAMPLE
 

SQL

select distinct after join

SELECT DISTINCT table1.field1, table2.field2 FROM table1
JOIN table2 ON table1.id = table2.id 
Comment

PREVIOUS NEXT
Code Example
Sql :: how to count number of rows in sql 
Sql :: oracle table free space 
Sql :: how to combine 2 tables in mysql 
Sql :: enable foreign key checks postgres 
Sql :: mysql delete database 
Sql :: mysql execute file 
Sql :: sql server to uppercase 
Sql :: mysql query with sql to get the next row 
Sql :: rename column in table sql 
Sql :: oracle index size 
Sql :: check database sessions oracle 
Sql :: mysql load sql from file 
Sql :: change data type in mysql 
Sql :: insert into select mysql 
Sql :: export mysql db using command line 
Sql :: oracle dba_dependencies 
Sql :: create table as select * from table mssql 
Sql :: how to select random rows from table 
Sql :: sql convert datetime 
Sql :: limit offset sql server 
Sql :: how to upper case in sql 
Sql :: oracle change tablespace size 
Sql :: sql 2nd highest salary 
Sql :: mysql default value 
Sql :: oracle parameter 
Sql :: mysql find duplicate rows multiple columns 
Sql :: insert into table from another table 
Sql :: login failed for login due to trigger execution 
Sql :: change schema in sql server 
Sql :: sqlite commands 
ADD CONTENT
Topic
Content
Source link
Name
4+2 =