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
- 50688 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
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
what is the difference between blob and text? : Sql dba
What are database links used for?
What are the usages of sql?
How many sql statements are used? Define them.
What is the command used to fetch the first 5 characters of a string?
What is mutating error?
Why is sharding used?
What is varchar used for?
How do you optimize a stored procedure query?
what is an index? : Sql dba
What are sql procedures?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
Why we use stored procedure instead of query?
How do I kill a query in postgresql?
What is query syntax?
