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
How do you write an inner join query?
what is the syntax used for partition in tsql? : Transact sql
Can we create table in function?
How do you determine the current isolation level? : Transact sql
What is sql basics?
What is primary key secondary key alternate key candidate key?
what is the difference between a having clause and a where clause? : Sql dba
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
In what condition is it good to disable a trigger?
What are the dml statements?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
what is isam? : Sql dba
Is coalesce faster than isnull?
What is a sql schema used for?
What are different types of tables in sql?