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
7923 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

generally what they ask in a client interview.regarding projects what they might ask?

2 Answers

what is meant by Test suite

4 Answers

What is top-down approach?

0 Answers

What is Test Data Collection?

1 Answers TCS,

in automation how can we post a bug?

1 Answers

Transaction Per second?

1 Answers

Explain stress testing?

0 Answers

Explain 3 high priority test cases for the performance of MSN search engine.

0 Answers HPCL, Hughes Systique Corporation,

What is API testing?

2 Answers

Explain a variable?

0 Answers

What is virtual address?

0 Answers

What is software fault?

0 Answers

For more Testing AllOther Interview Questions Click Here