1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used

Question Posted / nagireddyora

Answers were Sorted based on User's Feedback



how to delete duplicate rows from a specified table(only single table) how do you know which join..

Answer / kishor solanki @ 9904762204

create table newtable as select * from oldtable order by dupcol;
drop oldtable;
rename newtable to oldtable;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Explain unique key in sql.

0 Answers  

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

6 Answers   Accenture,

What are properties of the transaction?

0 Answers  

List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,

What is rownum and rowid?

0 Answers  




What is the maximum database size for sql express?

0 Answers  

How do you optimize a query?

0 Answers  

What are the types of sql commands?

0 Answers  

How do I view a view in sql?

0 Answers  

What are predefined functions in sql?

0 Answers  

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

0 Answers  

How do temporal tables work?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories