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
- 15831 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 | 2 No |
Post New Answer View All Answers
what is myisam? : Sql dba
What sql does db2 use?
What is database migration?
Does truncate require commit?
What does over partition by mean in sql?
What is rownum in sql?
Which constraints we can use while creating database in sql?
What is a crud api?
What does inner join mean?
What is the difference between joins?
What are different types of statements supported by sql?
What is parameter substitution in sql?
how to rename an existing table in mysql? : Sql dba
Can a primary key be a foreign key?
In a distributed database system, can we execute two queries simultaneously?
