Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 13 Answers
- 59063 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
What is a node in teradata?
Describe the set operators in teradata.
What is the use of fallback?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What do you mean by teradata sql assistant?
What are the joins in teradata?
What is real time and near real time data warehousing?
What are the different functions included in the server software?
Difference between multiload and tpump?
What do you mean by ttu in teradata?
What is basic teradata query language?
What is spool space?
What are the steps involved after the disk manager passes the request?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
