Sql Tour
Tuesday, December 4, 2012
Getting duplicate records with count
SELECT Type, count(*) as TotalCount FROM tblAgentTran
where kcode='4' group by type
having count(
) > 1 order by COUNT(
) DESC
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment