Interested to Buy Any Domain ? << Click Here >> for more details...
How to remove duplicate rows from a table?.
- 3 Answers
- 8443 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vamsi
for example our emp table have duplicate rows than we can
run this query to delete those duplicate rows
Delete from emp a
where rowid <> ( select max(rowid) from emp where empno =
a.empno);
| Is This Answer Correct ? | 13 Yes | 4 No |
Answer / lova raju allumalla
delete from emp where rowid not in (select min(rowid) from
emp group by empno);
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / karthik
with [dup_cte] as {
select row_number(partition by eid order by eid) as rn from emp}
go
delete from [dup_cte] where rn>1
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the difference between 'between' & 'and' operators in sql
How to use sql*plus built-in timers?
What are tuples in sql?
Why cross join is used?
what is not null constraint? : Sql dba
What are indexes, and what are the different types?
Explain how to use transactions efficiently : transact sql
how to create a new table by selecting rows from another table in mysql? : Sql dba
What can be a size of a pl/sql block? Is there any limit?
How to use transactions efficiently : transact sql
What is the difference between partition and index?
What does plv msg allows you to do?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
