Thread: How to display duplicate rows in a table
View Single Post
Old 15-07-08, 06:30 PM   #2 (permalink)
seemant
Junior Member
 
Join Date: Jul 2008
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 1 seemant is on a distinguished road
Re: How to display duplicate rows in a table
select column1 from tablename
where column1<>0
group by column1
having count(*)>1
__________________
seemant
Software Engineer
seemant is offline   Reply With Quote