how to retrieve only duplicate values in a table

Answer Posted / p.rajasekar

select count(<Duplicate_FieldName>),fees
from Table Name
group by <Duplcate_FieldName>
having count(<Duplicate_FieldName>)>1

Regards
P.Rajasekar

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an index in sql with example?

519


What is a dynamic query?

573


What is the max nvarchar size?

525


What is the function that is used to transfer a pl/sql table log to a database table?

557


What is a sql schema used for?

546






How to set up sql*plus output format in oracle?

598


What is the difference between between and in condition operators?

539


How do you add a column to a table?

606


What are the different dml commands in sql?

587


How can we make an if statement within a select statement?

543


Can we write dml inside a function in sql server?

501


How do you rename a table in sql?

534


What are the two types of exceptions.

638


What does partition by mean in sql?

515


how to include character strings in sql statements? : Sql dba

556