Re: update statement

  • From: Rumpi Gravenstein <rgravens@xxxxxxxxx>
  • To: Brian.Zelli@xxxxxxxxxxxxxxx, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 17 Feb 2011 15:15:38 -0500

Brian,

What do you see when you run this:

SELECT s_subjectid, COUNT(u_mrn)
 FROM annmarie.s_subject
GROUP BY s_subjectid
HAVING COUNT(u_mrn) > 1;


-- 
Rumpi Gravenstein

Other related posts: