Trim chat.

edit approved Jul 10, 2018 at 12:53

78
2
18

Here's the table in sql server.. and below is what I want to do. Any help would be appreciated.

TABLE:

Area (column 1) ----- Oregon California California California Oregon Washington Idaho Washington

I want ALL the cities that are duplicates to be returned, but not the distinct ones. Just the duplicates. Is there a select statement that lets me return only duplicates?

Here's the table in sql server.. and below is what I want to do. Any help would be appreciated.

TABLE:

Area (column 1) ----- Oregon California California California Oregon Washington Idaho Washington

I want ALL the cities that are duplicates to be returned, but not the distinct ones. Just the duplicates. Is there a select statement that lets me return only duplicates?

Here's the table in sql server.. and below is what I want to do.

TABLE:

Area (column 1) ----- Oregon California California California Oregon Washington Idaho Washington

I want ALL the cities that are duplicates to be returned, but not the distinct ones. Just the duplicates. Is there a select statement that lets me return only duplicates?

Improved Formatting

Source Link

edit approved Jun 17, 2015 at 12:18

User Learning

3.6k
7
32
51

Here's the table in sql server.. and below is what I want to do. Any help would be appreciated.

TABLE: Area (column 1)

Oregon
California
California
California
Oregon
Washington
Idaho
Washington TABLE:

Area (column 1) ----- Oregon California California California Oregon Washington Idaho Washington

I want ALL the cities that are duplicates to be returned, but not the distinct ones. Just the duplicates. Is there a select statement that lets me return only duplicates?

Here's the table in sql server.. and below is what I want to do. Any help would be appreciated.

TABLE: Area (column 1)

Oregon
California
California
California
Oregon
Washington
Idaho
Washington

I want ALL the cities that are duplicates to be returned, but not the distinct ones. Just the duplicates. Is there a select statement that lets me return only duplicates?

Here's the table in sql server.. and below is what I want to do. Any help would be appreciated.

TABLE:

Area (column 1) ----- Oregon California California California Oregon Washington Idaho Washington

I want ALL the cities that are duplicates to be returned, but not the distinct ones. Just the duplicates. Is there a select statement that lets me return only duplicates?

sql sql-server

added 6 characters in body; edited title

Source Link

edited Jul 14, 2013 at 4:07

user2246674

7.7k
27
28

How to select not distinctonly duplicate records?

Here's the table in sql server.. and below is what I want to do. Any help would be appreciated.

TABLE: Area (column 1)

Oregon
California
California
California
Oregon
Washington
Idaho
Washington

I want ALL the cities that areare duplicates to be returned. Not, but not the distinct ones. Just the duplicates. Is there a select statement that lets me return only duplicates?

Source Link

asked Jul 14, 2013 at 4:02

Nisar

6.1k
18
71
84

Loading

Collectives™ on Stack Overflow

Return to Question

TABLE: Area (column 1)

TABLE: Area (column 1)

How to select not distinctonly duplicate records?

TABLE: Area (column 1)

How to select not distinct

TABLE: Area (column 1)

How to select only duplicate records?

TABLE: Area (column 1)