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
- 18777 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
Write a query to find the names of users that begin with "um" in sql?
What is the largest value that can be stored in a byte data field?
how are mysql timestamps seen to a user? : Sql dba
How do you remove duplicate records from a table?
How to process query result in pl/sql?
How do I remove duplicates in two columns?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is sqlca in db2?
how to use like conditions? : Sql dba
what are the different type of sql's statements ? : Sql dba
Why is normalization important?
What is a loop in sql?
How can I change database name in sql?
Why is pl sql needed?
What is out parameter used for eventhough return statement can also be used in pl/sql?
