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?
Answer Posted / guest
unionall
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
what does the t-sql command ident_current does? : Transact sql
What is sql rowcount?
What is t sql in sql server?
Can we use the cursor's to create the collection in PL/SQL?
What is sql select statement?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
Why is sql better than hql?
What is dml with example?
Explain what is a column in a table?
what are all the different normalizations? : Sql dba
What are the different schemas objects that can be created using pl/sql?
Write a sql query to get the third highest salary of an employee from employee_table?
What is write ahead logging in sql server?
Is record in oracle pl sql?
What is a dynamic query?