SQL baze podataka - Sponzor: Baze-Podataka.net MySQL, MSSQL, Oracle, Access, ODBC. Ako imate problem brže i preciznije ćete dobiti odgovor ako priložite strukturu tabela ili skript koji kreira tabele i puni ih test podacima umesto što to problem opisujete samo rečima. Sponzor: Baze-Podataka.net - Blog o bazama podataka |
![]() |
|
Alati teme | Način prikaza |
![]() |
#1 |
Goran Pilipović
Sir Write-a-Lot
|
![]() imam tabelu a
a_id primary a_name ... imama tabelu b (1-n) b_id primary a_id index b_name Treba da dobijem jednim querijem sve recorde iz tabele a i za svaki tacno po 3 recorda iz tabele b koji imaju odgovovarajuci a_id znaci ako je tabela a: ----------- 1 prvo_ime 2 drugo_ime 3 trece_ime a tabela b: ------------ 1 1 lorem 2 1 ispum 3 1 dolom 4 1 sit 5 1 amet 6 2 nesto 7 2 drugo 8 2 neki 9 2 record 10 3 jos 11 3 jedan 12 3 record 13 3 nove 14 3 poruke 15 3 mrzi 16 3 me 17 3 vise ![]() treba da dobijem : 1 prvo_ime 1 1 prvo_ime 2 1 prvo_ime 3 2 drugo_ime 6 2 drugo_ime 7 2 drugo_ime 8 3 trece_ime 10 3 trece_ime 11 3 trece_ime 12 uh, valjda je jasno? ![]()
__________________
Goran Pilipović a.k.a. Ugly Fingers Bradley f.k.a. bluesman I don't always know what I'm talking about but I know I'm right! |
![]() |
![]() |
![]() |
#2 |
VD IT Direktora
Invented the damn thing
Datum učlanjenja: 08.06.2005
Lokacija: Beograd
Poruke: 2.118
Hvala: 503
1.307 "Hvala" u 282 poruka
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
![]() |
![]() |
#3 |
Goran Pilipović
Sir Write-a-Lot
|
![]() Tnx, brzo ali kuso
![]() To sam i ja uradio, ja gledam da probam bez subselect ![]()
__________________
Goran Pilipović a.k.a. Ugly Fingers Bradley f.k.a. bluesman I don't always know what I'm talking about but I know I'm right! |
![]() |
![]() |
![]() |
#4 |
old school
Professional
|
![]() Mene bas zanima, da li je to moguce uraditi bez podupita ...
Ako jeste, castim pivom i cevapima onog, koji pokaze da je moguce. ![]()
__________________
Blog: Baze podataka ------------------------ Oracle OCP DBA Oracle OCE SQL Expert Oracle OCP Developer Certified MySQL DBA |
![]() |
![]() |
![]() |
#5 |
Ivan Dilber
Sir Write-a-Lot
|
![]() tesko bez pod-upita, zbog onog limita na 3 elementa... zaista ne znam kako bi se to proguralo u klasican join...
__________________
Leadership is the art of getting people to want to do what you know must be done. |
![]() |
![]() |
![]() |
#6 | |
Banned
Knowledge base
Datum učlanjenja: 01.07.2005
Poruke: 1.598
Hvala: 206
140 "Hvala" u 89 poruka
![]() ![]() |
![]() Citat:
|
|
![]() |
![]() |
![]() |
#7 | |
profesionalac
Professional
Datum učlanjenja: 21.06.2005
Poruke: 294
Hvala: 93
525 "Hvala" u 19 poruka
![]() ![]() ![]() ![]() ![]() ![]() |
![]() Je l moze ovako?
Citat:
Poslednja izmena od BluesRocker : 17. 04. 2007. u 16:02. |
|
![]() |
![]() |
![]() |
#8 |
Goran Pilipović
Sir Write-a-Lot
|
![]() Ovo moram prvo da rastuimacim pa cu onda da ti kazem
![]()
__________________
Goran Pilipović a.k.a. Ugly Fingers Bradley f.k.a. bluesman I don't always know what I'm talking about but I know I'm right! |
![]() |
![]() |
![]() |
#9 |
Banned
Knowledge base
Datum učlanjenja: 01.07.2005
Poruke: 1.598
Hvala: 206
140 "Hvala" u 89 poruka
![]() ![]() |
![]() upravo sam isprobao, ovo radi
![]() Svaka ti se dala. Za cevape se javi ![]() |
![]() |
![]() |
![]() |
#10 |
Goran Pilipović
Sir Write-a-Lot
|
![]() samo sada treba uraditi jedan "explain ... " da vidimo da li je efikasno
__________________
Goran Pilipović a.k.a. Ugly Fingers Bradley f.k.a. bluesman I don't always know what I'm talking about but I know I'm right! |
![]() |
![]() |
![]() |
|
|
![]() |
||||
Tema | Početna poruka teme | Forum | Odgovori | Poslednja poruka |
Najgori SQL query na svetu | bluesman | SQL baze podataka - Sponzor: Baze-Podataka.net | 83 | 20. 12. 2011. 01:17 |
Id, kategorija - jedan query | Ivan | SQL baze podataka - Sponzor: Baze-Podataka.net | 4 | 13. 11. 2007. 03:09 |
spor query | ivanhoe | SQL baze podataka - Sponzor: Baze-Podataka.net | 1 | 31. 07. 2007. 19:47 |
Pisanje mysql query | bluesman | SQL baze podataka - Sponzor: Baze-Podataka.net | 30 | 05. 06. 2007. 12:53 |
mysql, php i unbuffered query | ivanhoe | SQL baze podataka - Sponzor: Baze-Podataka.net | 1 | 21. 07. 2006. 04:50 |