Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used
- 11 Answers
- 18865 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How would you convert date into julian date format?
How many functions are there in sql?
Does execute immediate commit?
Why left join is used in sql?
How is pl sql different from sql?
How can I delete duplicate rows?
Do we need to rebuild index after truncate?
What is bind reference and how can it be created?
Explain the rollback statement?
What is the size of partition table?
Explain what is dbms?
Can we rollback delete command?
What are the different types of dbms?
what is an extent ? : Sql dba
How would you pass hints to the sql processor?
