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
- 51824 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / lavanya
SELECT COUNT(*), <COLUMN_NAME> FROM EDUCATION GROUP BY
<COLUMN_NAME>
| Is This Answer Correct ? | 10 Yes | 14 No |
Post New Answer View All Answers
How can we link a sql database to an existing android app?
Can we insert in view in sql?
How do I install sql?
Is sql the best database?
Define sql delete statement.
What are joins in sql?
What is sqlite format?
What is numeric function sql?
How do you delete duplicates in sql query using rowid?
Do we need to create index on primary key?
What is sql integrity?
How can you create an empty table from an existing table?
What do you understand by pl/sql cursors?
How is a process of pl/sql compiled?
Define the select into statement.
