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

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 / yankee

If you wish to remove duplicate values, then use the
DISTINCT parameter.
Consider there is a table:emp, with deptno. as one of its
coloumn. This coloumn has repeated values. Then you should
use the following query to remove the duplicate values:
SELECT DISTINCT deptno FROM emp;

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

how to get second highest salary in SQL(as/4000

29 Answers   iGate,


Is sql pronounced sequel or sql?

0 Answers  


What is Difference Between delete and Truncate?

9 Answers  


how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

0 Answers  


write a query to delete similar records in same table

13 Answers   TCS,


What is Highwatermark?

3 Answers   Thermotech,


Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,


Is left join faster than inner join?

0 Answers  


what are the forced views

6 Answers   Hexaware, TCS,


How do I run pl sql in sql developer?

0 Answers  


Does truncate remove indexes?

0 Answers  


how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  


Categories