|
View previous topic :: View next topic
|
| Author |
Message |
kespra
Currently Banned
New User
Joined: 03 Jun 2008
Posts: 24
Location: bangalore
|
|
|
|
In a column I want only duplicates to be selected what should I do?Take col has values 1
1
2
2
3
3 |
|
| Back to top |
|
 |
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hello,
You can use following query
select colum1 from table1
group by colum1
having count(*) >1
will give you result as
2
3
Hope i understand ur question correctly |
|
| Back to top |
|
|
|
|
