Answer Posted / Manish Kumar Dwivedi
You can use a subquery to find duplicates in multiple columns. For example: SELECT column1, column2 FROM table WHERE (column1, column2) IN (SELECT column1, column2 FROM table GROUP BY column1, column2 HAVING COUNT(*) > 1).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are aggregate and scalar functions? : Sql dba
what are all the common sql function? : Sql dba
what is collation? : Sql dba
Does group by remove duplicates?
What is the current version of sql?
Can delete statement be rollbacked?
Is inner join faster than left join?
What is the best sql course?
Is primary key clustered index?
If a cursor is open, how can we find in a pl/sql block?
What is the current version of postgresql?
how to use regular expression in pattern match conditions? : Sql dba
Do we need to rebuild index after truncate?
Can we rollback truncate?
define sql insert statement ? : Sql dba
