|
View previous topic :: View next topic
|
| Author |
Message |
Shriram Jogdand
New User
Joined: 14 Oct 2008
Posts: 65
Location: Pune
|
|
|
|
Hi,
I want to run query which will fetch only rows that are duplicate? |
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hello Sriram,
You need to provide the basis for duplicate rows. Is it contain same value for all the column etc. I am afraid without which suggestion would nt be of much help. |
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
Is this ok for you?
| Code: |
SELECT col1,COUNT(*)
FROM tab1
GROUP BY col1
HAVING COUNT(*) > 1;
|
|
|
| Back to top |
|
|
Shriram Jogdand
New User
Joined: 14 Oct 2008
Posts: 65
Location: Pune
|
|
|
|
| Thanks Sambhaji. |
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
| I am glad, I could GUESS your requirement. |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
Must have been psychic day  |
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
| expat wrote: |
| Must have been psychic day |
I think getting up late from bed nourishes being telepathic |
|
| Back to top |
|
|
|
|
