Sign Up Login


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

Explian rowid, rownum? What are the psoducolumns we have?

0 Answers  

Which is the best place to learn hadoop?

1 Answers  

What is sap sql anywhere?

0 Answers  

How can check sql version from command line?

0 Answers  

i need department wise top 2 employees salary.which logic i will use

17 Answers  

Explain what is a column in a table?

0 Answers  

Types of cursor locks and explanation each of them ?

3 Answers   DELL, HP Finsoft,

What is primary key and unique key?

0 Answers  

What are the string functions in sql?

0 Answers  

What is a system versioned table?

0 Answers  

Explain what is table in a database?

0 Answers  

What is pessimistic concurrency control? : Transact sql

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories