<http://schema.org/articleBody>
"Doug, To use GROUP BY and HAVING, you'd need something like this: With tbl as (select escan From mytable Group by escan Having count(*) &amp;gt; 1 ) Select escan, eitnbr from mytable where escan in (select escan from tbl) order by escan, eitnbr note: if it is ok ..."^^<http://www.w3.org/2001/XMLSchema#string>
<http://archive.midrange.com/midrange-l/200807/msg01413.html>