>Is it possible to find only duplicate records using Stonefeild Query?

I think you may need to use Advanced step to create your query, which is simple in itself.

select myTable.* from myTable inner join (select Dupfield, count(*) as Dups from myTable group by myDupFields having Dups>1) Dups on myTable.DupField = Dups.DupField