Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
  b=xYgHhVGNDrTBuR+LGDYUDWRLbhEbWZRhdz7yBPFYg7qUIVVWQAG8rzgfCbWrZ4Gxpr5AXG67akt0YUL2SzJGoFr8iT368bfOcGrDxOLkXHEIyLGrJsWdY1gs2tKTde9lfwPNE00oNE5vc6qE/AdVVZg+lL5i19iq3BIoWRsvWdk=;
Date: Thu, 22 Nov 2007 06:40:52 -0800 (PST)
From: Aneez Backer <aneez_backer@yahoo.com>
Subject: Re: Derby Equivalent of MySql queries
To: Derby Discussion <derby-user@db.apache.org>
In-Reply-To: <20071122095036.GA22923@khepri35.norway.sun.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1310316641-1195742452=:98927"
Content-Transfer-Encoding: 8bit
Message-ID: <738361.98927.qm@web51603.mail.re2.yahoo.com>

--0-1310316641-1195742452=:98927
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi 

The tables are being used for dynamic update and count of notification whenever a  pre-defined change is made in any of the columns. Also, I had posted the trigger statement in a simplified form omitting data from it for which I knew I could work on myself.

Hope that answers your query.

Can you help me with one more transformation??

select * TABLEA where uid in (101,102,103) order by creation_time limit 5"

The problem here is with the 'limit 5' part of the query

Also, can you let me know of any online tutorial help available for learning Derby Query basics ??

Thanks
-aneez

"Bernt M. Johnsen" <Bernt.Johnsen@Sun.COM> wrote: Hi,

>>>>>>>>>>>> Aneez Backer wrote (2007-11-21 20:05:01):
> Thanks Bernt.
> 
> That helped

Just a small question: Is there some special (e.g. performance)
requirements that force you to maintain the data in TABLEB? Since

SELECT TAGCOUNT FROM TABLEB WHERE ID=xxx;

should give the same result as

SELECT COUNT(TAG_ID) FROM TABLEA WHERE TAG_ID=xxx;

you could perhaps do without the triggers and TABLEB?
-- 
Bernt Marius Johnsen, Database Technology Group, 
Staff Engineer, Derby/Java DB
Sun Microsystems, Trondheim, Norway


---------------------------------
Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how.
--0-1310316641-1195742452=:98927
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi <br><br>The tables are being used for dynamic update and count of notification whenever a&nbsp; pre-defined change is made in any of the columns. Also, I had posted the trigger statement in a simplified form omitting data from it for which I knew I could work on myself.<br><br>Hope that answers your query.<br><br>Can you help me with one more transformation??<br><br><span style="font-weight: bold;">select * TABLEA where uid in (101,102,103) order by creation_time limit 5"</span><br><br>The problem here is with the <span style="font-weight: bold;">'limit 5' </span>part of the query<br><br>Also, can you let me know of any online tutorial help available for learning Derby Query basics ??<br><br>Thanks<br>-aneez<br><br><b><i>"Bernt M. Johnsen" &lt;Bernt.Johnsen@Sun.COM&gt;</i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> Hi,<br><br>&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt; Aneez Backer
 wrote (2007-11-21 20:05:01):<br>&gt; Thanks Bernt.<br>&gt; <br>&gt; That helped<br><br>Just a small question: Is there some special (e.g. performance)<br>requirements that force you to maintain the data in TABLEB? Since<br><br>SELECT TAGCOUNT FROM TABLEB WHERE ID=xxx;<br><br>should give the same result as<br><br>SELECT COUNT(TAG_ID) FROM TABLEA WHERE TAG_ID=xxx;<br><br>you could perhaps do without the triggers and TABLEB?<br>-- <br>Bernt Marius Johnsen, Database Technology Group, <br>Staff Engineer, Derby/Java DB<br>Sun Microsystems, Trondheim, Norway<br></blockquote><br><BR><BR><div> <div> <div> <div> <div> <div> <div> <div> <div> <div> <div> <div> <div><br></div></div></div></div></div></div></div></div></div></div></div></div></div><p>&#32;
      <hr size=1>Be a better pen pal. 
Text or chat with friends inside Yahoo! Mail. <a href="http://us.rd.yahoo.com/evt=51732/*http://overview.mail.yahoo.com/">See how.</a>
--0-1310316641-1195742452=:98927--