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 / "d"
select count(*),ss from dd group by
ss having count(*)>1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you respond to dementia behavior?
What is a sql schema used for?
What does trigger mean in slang?
How to Execute a Package in PL/SQL.?
How do you clear the screen in sql?
Is oracle and sql same?
What is the largest value that can be stored in a byte data field?
How do you sort in sql?
What is a nested table in word?
What mean sql?
How to pipe multiline string to isql?
what are numeric data types? : Sql dba
what does the t-sql command ident_current does? : Transact sql
What do you mean by dbms? What are its different types?
What are the usages of sql?