Hope this will help, DELETE FROM EMPLOYEE WHERE (EMP_ID,EMP

Write a single SQL to delete duplicate records from the a
single table based on a column value. I need only Unique
records at the end of the Query.

Question Posted / guest

13 Answers
59019 Views
I also Faced
E-Mail Answers

Answer Posted / guest

Hope this will help,

DELETE FROM EMPLOYEE
WHERE (EMP_ID,EMP_NAME) IN
(SELECT EMP_ID,EMP_NAME FROM
(SELECT EMP_ID,EMP_NAME ,ROW_NUMBER() OVER (PARTITION BY
EMP_ID,EMP_NAME ORDER BY EMP_ID,EMP_NAME) AS FLG
FROM EMPLOYEE) A
WHERE
A.FLG<>1)

Is This Answer Correct ?

4 Yes

10 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the available primary index types in teradata.

965

What is the use of teradata system software?

981

What is the opening step in basic teradata query script?

973

Explain BYNET.

946

Highlight the advantages of PPI(Partition Primary Index).

1004

If a Node is busy what are the steps you can take to avoid ?

2344

What is logical data model?

1136

What are the string manipulation operators and functions associated with teradata?

1021

Difference between multiload and tpump?

1036

What is difference between user and database in teradata?

1022

how can we analyze the locks ?

2058

What is the syntax for case when statement?

1053

What are the different functions performed in development phase?

1012

How do you determine the number of sessions?

1007

Which is faster fastload or multiload?

1035