>
--0016e6d783fccdeadd0476faa646
Content-Type: text/html; charset=ISO-8859-2
Content-Transfer-Encoding: quoted-printable
probaj:<br>SELECT �a.model as model_i, b.model as model_j, a.speed, b.ram<br><br><br><br><br><div class="gmail_quote">2009/10/28 Emp <span dir="ltr"><<a href="mailto:
[email protected]">
[email protected]</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Vje�bam malo ovih dana sql i nai�oh na problem kod jednog zadatka.<br>
Evo o �emu se radi.<br>
<br>
Imamo slede�u tabelu:<br>
PC(code, model, speed, ram, hd, cd, price)<br>
<br>
Zadatak je slede�i:<br>
Find the pairs of PC models having similar speeds and RAM. As a result, each resulting pair is shown only once, i.e. (i, j) but not (j, i).<br>
Result set: model with higher number, model with lower number, speed, and RAM. <br>
<br>
Moje rje�enje je bilo : <br>
<br>
Ali ovo rje�enje ne radi.<br>
U pitanju je jedno od zadataka sa sajta za vje�banje (<a href="
http://www.sql-ex.ru" target="_blank">
www.sql-ex.ru</a>: <a href="
http://www.sql-ex.ru" target="_blank">
http://www.sql-ex.ru</a> ).<br>
Ta�nije, vje�ba broj 16.<br>
I evo zaglavio sam na nju ve� 2-3 dana i nema �anse da je pre�em.<br>
Gdje grije�im u mom rje�enju?<br><font color="#888888">
<br>
--<br>
<a href="
http://www.elitesecurity.org/p2424602" target="_blank">
http://www.elitesecurity.org/p2424602</a><br>
<br>
Prijave/odjave: <a href="
http://www.elitesecurity.org/liste" target="_blank">
http://www.elitesecurity.org/liste</a><br>
<br>
Ne menjajte sledece dve linije ukoliko odgovarate putem emaila!<br>
esauth:379887:793c78a6e8171f389475bb12f3d78d7d<br>