本文介绍了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次出现的列值的行?
发布评论