Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve Duplicate Rows only in a Table?
Suppose if a Table Name is "Education". It consists of
multiple columns. Then if we insert rows into this table
with duplicate records then how can we retrieve only
duplicate records from that table?
- 29 Answers
- 51844 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / balaji
For Sample:
----------
select count(pmid) as Occurances,pmid from tablename group
by pmid having count(pmid)>1
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What do you mean by rowid?
What is the difference between local variables and global variables?
How do you update a table in sql?
what are enums used for in mysql? : Sql dba
How much does a sql dba make? : SQL DBA
what is rollback? : Sql dba
Which join is like an inner join?
How do I make my sql query run faster?
What does the sign mean in sql?
What is composite primary key in sql?
Mention what is the plv (pl/vision) package offers?
Which tcp/ip port does sql server run?
How run sql*plus commands that are stored in a local file?
What is the usage of when clause in trigger?
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
