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
- 19250 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
When is the update_statistics command used?
where are cookies actually stored on the hard disk? : Sql dba
What are the types of sql commands?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is sql entity?
Is sql between inclusive?
How would you convert date into julian date format?
Why procedure is used in sql?
What mean sql?
What is primary key in db?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
how tsql statements can be written and submitted to the database engine? : Transact sql
Why do we need unique key in a table?
Is left join and outer join same?
How to create an array in pl/sql?
