Wednesday, 25 April 2012

Getting duplicate element in table

select question_id,question_text,count(*) as cnt
from question group by question_text having cnt > 1

No comments :

Post a Comment