Select duplicate column values

r123456 · #1 (**permalink**) 10-13-03, 10:21

Hi,

How do I select rows that contain the duplicate values for a giev column.

Eg,

C1 | C2
a
b
a

I need to select a.

Cheers.

r937 · #2 (**permalink**) 10-13-03, 10:52

select C1, C2
from yourtable
where C1 in
( select C1 from yourtable
group by C1
having count(*) > 1 )

Sathya65 · #3 (**permalink**) 11-28-11, 14:24

Hi,

I want to select only one duplicate value from the column + select other values.

For ex:

Column 1 Column 2 Column 3

28/11/2011 Item 1 Received

27/11/2011 Item 2 Received

24/11/2011 Item 3 Pending

28/11/2011 Item 4 Pending

25/11/2011 Item 5 Pending

I want to get output like this :

24/11/2011

25/11/2011

27/11/2011

28/11/2011 ----> This is single value from the duplicate values and also

sorted.

If any one know how to get this output, please reply.

r937 · #4 (**permalink**) 11-28-11, 14:34

wow, an 8-year-old thread, answered within 10 minutes

Quote:

Originally Posted by Sathya65

If any one know how to get this output, please reply.

Code:

SELECT DISTINCT column1
  FROM daTable
ORDER
    BY column1

Sathya65 · #5 (**permalink**) 11-28-11, 17:02

Thanks a lot. It work's. What is your name?

r937 · #6 (**permalink**) 11-28-11, 19:25

i am the rudeboy, the rudester, the sqlmeister

Internet Services

Web Development

Digital Marketing

Consumer Tech