Re: update statement
From: Rumpi Gravenstein <rgravens_at_gmail.com>
Date: Thu, 17 Feb 2011 15:15:38 -0500
Message-ID: <AANLkTimko+=S+v8Ap3hREhaohzVq-xy2iOj30mUWs7YU_at_mail.gmail.com>
Brian,
Date: Thu, 17 Feb 2011 15:15:38 -0500
Message-ID: <AANLkTimko+=S+v8Ap3hREhaohzVq-xy2iOj30mUWs7YU_at_mail.gmail.com>
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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 17 2011 - 14:15:38 CST