Sunday, November 13, 2011

finding multiple rows with HAVING

select cityname from cities groupby cityname having count(*) > 1

No comments:

Post a Comment