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
- 19620 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
what is the difference between a having clause and a where clause? : Sql dba
What are the constraints available in sql?
Which tcp/ip port does sql server run?
What is %s in sql?
What is procedure explain with program?
what is a database? : Sql dba
How to pronounce postgresql?
Can we join same table in sql?
What is sql*plus?
What is sqlca in db2?
is it possible to pass an object or table to a procedure as an argument?
What are system versioned tables?
What is sql performance tuning?
What are triggers and its uses?
What is the difference between the sql*loader and import utilities? : aql loader
