本文介绍了SQL:选择列值至少出现 N 次的行?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
假设我有一个包含两列的 SQL 表Celebrities":fname"和lname":
Suppose I have a SQL table "Celebrities" with two columns: "fname" and "lname":
fname | lname ---------+------- Bill | Clinton Bill | Gates George | Bush George | Clinton Barack | Obama我想编写一个查询,返回表中每个人的名字和姓氏,这些人的姓氏在lname"列中至少出现两次.如何编写此 SQL 查询?
I would like to write a query that returns the first and last name of each person in the table whose last name appears at least twice in the column "lname". How do I write this SQL query?
推荐答案 SELECT fname, lname FROM Celebrities WHERE lname IN (SELECT lname FROM Celebrities GROUP BY lname HAVING COUNT (lname) >1)更多推荐
SQL:选择列值至少出现 N 次的行?
发布评论