-
duplicate rows
How to delete duplicate records from one table.
-
DELETE from < 'tablename'>
WHERE rowid not in
(SELECT MIN(rowid)
FROM our_table
GROUP BY COLUMN1(USE PRIMARY_KEY))
-
Originally Posted by ams-jamali
DELETE from < 'tablename'>
WHERE rowid not in
(SELECT MIN(rowid)
FROM our_table
GROUP BY COLUMN1(USE PRIMARY_KEY))
Thanks....
Gopu
Last edited by gopu_g; 04-17-2008 at 02:47 AM.
-
I f u know to do a google search, why did you post this message here?
-
Originally Posted by malay_biswal
I f u know to do a google search, why did you post this message here?
if you know the answer post it..?
a poster can find the answer in different ways..
-
Code:
if you know the answer post it..?
a poster can find the answer in different ways..
Oh Yeah u dumb ass...
-
Originally Posted by malay_biswal
Code:
if you know the answer post it..?
a poster can find the answer in different ways..
Oh Yeah u dumb ass...
R u a DBA....?
we can find the answer in different ways..
for getting the correct answer from the experts the people are posting in the forums like this.....
why i posted the link there is may be it is helpful to somebody.. not to you...because i know you are an expert
-
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Originally Posted by malay_biswal
[CODE]
Oh Yeah u dumb ass...
this is not place to use these kind of languages....
-
Any guesses why you are having kind of verbal fights with lot of people around here since last 3-4 days. Think on it. It might get usefull for you in future.
Rgds
Parag
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|