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
What is an index in sql with example?
What is a dynamic query?
What is the max nvarchar size?
What is the function that is used to transfer a pl/sql table log to a database table?
What is a sql schema used for?
How to set up sql*plus output format in oracle?
What is the difference between between and in condition operators?
How do you add a column to a table?
What are the different dml commands in sql?
How can we make an if statement within a select statement?
Can we write dml inside a function in sql server?
How do you rename a table in sql?
What are the two types of exceptions.
What does partition by mean in sql?
how to include character strings in sql statements? : Sql dba