oracle排除重复名字_用于查找非重复行的Oracle查询

I will try to put forward this question in a simple way. Consider that I have a table with two columns (Name, Contact_No). We can have the same name but with different Contact No in the table. All I want to know is to find out which name is NOT repeated in the entire table. Or in other words, which name is unique in this table and has appeared only once.. This is just an example, the actual scenario is quite different but if anyone can help me with this example, I'll be able to handle the actual scenario.

Here is an example

Name Contact_No

A 123

A 124

B 125

C 126

C 127

All I want is to find (B) which is not repeated in the entire table. Thanks

解决方案

You can simply do this:

SELECT name FROM tbl_name GROUP BY name HAVING COUNT(name) = 1

Check Out