All pastes #163448 Raw Edit

Stuff

public text v1 · immutable
·published 2006-09-07 15:16 UTC
rendered paste body
select *
from SERVICE.mdb.dbo.hier
where upper(hier_parent) in
(
	select upper(hier_parent)
	FROM SERVICE.mdb.dbo.hier
	GROUP BY upper(hier_parent)
	HAVING (COUNT(UPPER(hier_parent)) > 1))