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,

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

Original text of this message