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

Explain smoke testing?

0 Answers

Hi All, This is regarding ETL testing. I have 3.5 years of experience in software testing. I have used web and DB testing so far. I am currently projected for ETL testing by using which is very new to me. We are using Informatica for running the sessions and taking the logs. I would like to know whats the process we have to follow for this testing. Ie., From kickoff to signoff. Can please anyone give brief explanation on that. Do we have any certification for ETL Testing??

152 Answers ABC, IBM, Satyam, Virtusa,

What is the testing process you follow in your organization?

0 Answers Wells Fargo,

What is utilization?

0 Answers

What is coverage measurement?

0 Answers

Hi I would like to ask a general question, I finished my post graduation(arts)a long back say 2000. I have a diploma in IT. And I have completed a course in testing(2010). What are my chances of getting a job in testing. I really have an apitude for testing and if given an opputunity I will do well. But I have been sent away after apitude tests which I know I did well(3 or 4 might have gone wrong), hr rounds. Can u tell me if I will get a job at all. Really I feel very let down. Give suggestions that will work thanx

1 Answers

what is the actual time to stop testing a product.

2 Answers

What is the difference between IIS web server & Apache TOmcat server

4 Answers ArisGlobal,

How you find the performance of a web application by looking at the values of ?Response Time? and ?Pages Per Second??

1 Answers

What is the main objective when reviewing a software deliverable?

0 Answers

What is life cycle?

0 Answers

What are cookies? Tell me the advantage and disadvantage of cookies?

2 Answers TCS,

For more Testing AllOther Interview Questions Click Here