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 difference between stored function and application function?
what does the t-sql command ident_incr does? : Transact sql
what are date and time data types in mysql? : Sql dba
How many aggregate functions are available there in sql?
How can I get the number of records affected by a stored procedure?
Do we need to create index on primary key?
What is the difference between clustered and non-clustered index in sql?
What is cursor status?
What is java sql package?
How many types of triggers are there in pl sql?
What is rownum in sql?
how to concatenate two character strings? : Sql dba
Which one is faster ienumerable or iqueryable?
Why we use triggers in mysql?
What is the difference between delete and truncate statement in sql?
