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
Do stored procedures prevent sql injection?
How to check if a column is nullable before setting to nullable?
Are stored procedures faster than queries?
How can I change database name in sql?
What is constant in pl sql?
Which type of cursor is used to execute the dml statement?
Why do we need databases?
What are transaction and its controls?
What are all the different normalizations?
Is primary key clustered or nonclustered?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What are the three pl sql block types?
What are actual parameters and formal parameters?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Does inner join return duplicate rows?