Interested to Buy Any Domain ? << Click Here >> for more details...
How to remove duplicate rows from a table?.
- 3 Answers
- 8306 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 |
What are basic techniques of indexing?
What is the difference between left and left outer join?
Explain the difference between drop and truncate commands in sql?
How much ram can sql express use?
What is error ora-12154: tns:could not resolve the connect identifier specified?
Explain polymorphism in pl/sql.
What is substitution variable in pl sql?
Is nosql relational?
Do you know the basic structure of PL/SQL?
How do you take the union of two tables in sql?
Does pl/sql support create command?
What is union and union all keyword in sql and what are their differences?
-
Oracle (3259) - 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)
