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
- 50681 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / kalaiselvan.j
select count(*),column_name from table_name group by
column_name having count(*)>1
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
Which data dictionary views have the information on the triggers that are available in the database?
How can I delete duplicate rows?
How to get each name only once from an employee table?
What is sql resultset?
What is foreign key in sql with example?
How many sql are there?
What is the cause of mutating table error and how can we solve it?
What is Difference Between Unique and Primary Key Constraints?
when MSQL8.0 is in market
What does cursor do in sql?
What is primary key and unique key?
What are the types of join and explain each?
What is scalar function in sql?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
How bulk collect improves performance?
