How to delete duplicates records in teradata without any tables....? with only

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

Question Posted / m.chanti

3 Answers
7767 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / suganya

SELECT DISTINCT column_name(s)
FROM table_name

Is This Answer Correct ?

9 Yes

2 No

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

Answer / 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

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

Answer / uma

Select Column_name from table_name group by column_name having count(column_name)>1

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Testing AllOther Interview Questions

What are test comparators?

0 Answers

Does functional testing comes under Black box or white box testing?

4 Answers Infeneon Technologies, S1 Services,

What is the difference between top-down and bottom-up testing?

0 Answers

HOW TO LEARN VB SCRIPTING IN FEW DAYS AND EASIEST WAY

1 Answers

Functional testing?

0 Answers

What is difference between SAN and NAS? How SAN is better than NAS?

0 Answers

What is software verification?

0 Answers

is manual testing enough for 2+ yrs,does it need any tools

0 Answers

What parameters to consider for Performance Testing?

6 Answers Virtusa,

How is an sql query executed in oracle 8?

0 Answers

What is api (application programming interface)?

0 Answers

What is a Test Plan and What it contains?

2 Answers Virtusa,

For more Testing AllOther Interview Questions Click Here