How to find duplicate rows?

How can I find the duplicate rows in a table?
Thanks.
LaEsmeraldaselect [field1],[field2]
from YourTable
group by [field1],[field2]
having count(*) > 1
http://sqlservercode.blogspot.com/