DELETE FROM table_name A WHERE ROWID > (SELECT min(rowid) FROM table

How to delete duplicates records in teradata without any
tables....?
with only one single query,,,?

Question Posted / jain

Answer Posted / jain

DELETE FROM table_name A WHERE ROWID > (SELECT min(rowid)
FROM table_name B WHERE A.key_values = B.key_values)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is modular framework?

1084

What the meaning of breath testing is?

996

Describe your ideal working environment.

2789

What is different type testing you done when doing webbase application.the desktop application

1882

How will you handle a conflict amongst your team members?

951

Every One is saying that Documentation is very very importent in Tester's Life.Could any one explain with proper examples..?

2172

What the meaning of code walk through is?

1112

Have you performed tests on the front-end and the back-end?

1027

What is a variant?

1009

What is quality policy?

1055

What is SDLC and STLC? In analysis phase of SDLC, what exactly the testers will do?

2231

What test plans consists of?

1006

What is the negative and positive testing?

1176

What is maintenance testing?

1046

Which is not a tool of static code analysis? a.)Ada b.)Borland-delphi c.)Fortan d.)None

2538