180606_Combine&Find

作者: 郑磊_4135 | 来源:发表于2018-06-06 10:22 被阅读0次

合并后,查找未出现的ID

Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never order anything.

Id Name
1 Joe
2 Henry
3 Sam
4 Max

Table: Customers.

Id Name
1 Joe
2 Henry
3 Sam
4 Max
Id CustomerId
1 3
2 1

Table: Orders.

Id CustomerId
1 3
2 1
Customers
Henry
Max

Using the above tables as example, return the following:

Customers
Henry
Max
SELECT C.Name as Customers
FROM Customers C
WHERE C.Id NOT IN (SELECT CustomerId
                  FROM Orders);

相关文章

  • 180606_Combine&Find

    合并后,查找未出现的ID Suppose that a website contains two tables, ...

网友评论

    本文标题:180606_Combine&Find

    本文链接:https://www.haomeiwen.com/subject/csavsftx.html