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 db journal file?
What will you get by the cursor attribute sql%notfound?
What is procedure explain with example?
What is the difference between database trigger and stored procedure?
Can a commit statement be executed as part of a trigger?
Is natural join and inner join same?
Why does sql need a server?
What is the difference between sql and isql*plus?
What is the difference between a database and a relational database?
Is pl sql useful?
What is a field in a database?
How to take user input in pl sql?
What is pl sql collection?
Can we insert data into materialized view?
what is the difference between delete and truncate statement in sql? : Sql dba