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: