Breaking News: Grepper is joining You.com. Read the official announcement!

sql join on select any duplicate column

Sorann answered on October 10, 2021 Popularity 5/10 Helpfulness 6/10

answer sql join on select any duplicate column

related sql select duplicates based on two columns

sql join on select any duplicate column

Comment

-- Let's say you have Customers table and Orders table
-- and both have CustomerID in common.
-- To avoid getting the column "CustomerID" two times,
-- you should use the Natural Join like so
SELECT *
FROM Customers
NATURAL JOIN Orders;

-- instead of
SELECT *
FROM Customers c
INNER JOIN Orders o ON c.customerID = o.customerID;

Popularity 5/10 Helpfulness 6/10 Language sql

Source: stackoverflow.com

Tags: any join select sql

Link to this answer
Share Copy Link

Contributed on Feb 14 2024

Sorann

0 Answers Avg Quality 2/10

Closely Related Answers

sql select duplicates based on two columns

Comment

select s.id, t.* 
from [stuff] s
join (
    select name, city, count(*) as qty
    from [stuff]
    group by name, city
    having count(*) > 1
) t on s.name = t.name and s.city = t.city

Popularity 9/10 Helpfulness 5/10 Language sql

Source: stackoverflow.com

Tags: select se

Link to this answer
Share Copy Link