http://feeds.feedburner.com/SpendYourTimeHere-Once

Current Affiares

Monday, July 16, 2012

How to count no of duplicate record in a field of a table?

select count(*) as 'NoOfRecord',fname from test 
group by fname having count(fname)>1

No comments:

Post a Comment

My Blog List

Popular Posts

All Rights Reserved To SYTHONCE. Ethereal theme. Powered by Blogger.