Problema SQL Join

#1
93kts

Posted 26 March 2016 - 12:13

Junior Member

Grup: Junior Members
Posts: 36
Înscris: 31.01.2016

Buna ziua !

Ma poate ajuta cineva cu : SELECT c.* , p.* FROM cotos_escorte c,cotos_poze_escorte p WHERE c.id=p.e_id

preia corect dar as vrea pentru tabela cotos_escorte sa-mi afiseze doar 10 iar pentru cotos_poze_escorte doar 1.. Cum pot face ?

Back to top

#2
Cristianssenn

Posted 26 March 2016 - 13:32

New Member

Grup: Members
Posts: 9
Înscris: 28.01.2007

select top 10 *
from (Select row_number() over (partition by c.id  order by p.id) as Part_id,
                    c.id as ce_id,
                    p.id as cpe_id,
                   *
         from cotos_escorte c inner join cotos_poze_escorte p on c.id=p.e_id
order by c.id, p.id) x
where x.part_id = 1 order by x.ce_id

Daca  baza de date este MSSQL, regasesti la link-ul urmator mai multe informatii: https://msdn.microso...y/ms189461.aspx

Back to top

#3
93kts

Posted 26 March 2016 - 13:56

Junior Member

Grup: Junior Members
Posts: 36
Înscris: 31.01.2016

Cristianssenn, on 26 martie 2016 - 13:32, said:

select top 10 *
from (Select row_number() over (partition by c.id  order by p.id) as Part_id,
c.id as ce_id,
p.id as cpe_id,
   *
from cotos_escorte c inner join cotos_poze_escorte p on c.id=p.e_id
order by c.id, p.id) x
where x.part_id = 1 order by x.ce_id

Daca  baza de date este MSSQL, regasesti la link-ul urmator mai multe informatii: https://msdn.microso...y/ms189461.aspx

Mersi mult ! Acum incerc sa vad ce iese ! :-D

Imi da : mysql_fetch_array() expects parameter 1 to be resource,

Edited by 93kts, 26 March 2016 - 14:03.

Back to top

#4
Cristianssenn

Posted 26 March 2016 - 17:03

New Member

Grup: Members
Posts: 9
Înscris: 28.01.2007

Mda, in Mysql trebuie pusa o virguala intre ...partiton by c.id, order by p.id...

Ex: http://stackoverflow...number-in-mysql

Back to top

Anunturi

Neurochirurgie minim invazivă

"Primum non nocere" este ideea ce a deschis drumul medicinei spre minim invaziv.

Avansul tehnologic extraordinar din ultimele decenii a permis dezvoltarea tuturor domeniilor medicinei. Microscopul operator, neuronavigația, tehnicile anestezice avansate permit intervenții chirurgicale tot mai precise, tot mai sigure. Neurochirurgia minim invazivă, sau prin "gaura cheii", oferă pacienților posibilitatea de a se opera cu riscuri minime, fie ele neurologice, infecțioase, medicale sau estetice.

www.neurohope.ro

Problema SQL Join

#1 93kts Posted 26 March 2016 - 12:13

#2 Cristianssenn Posted 26 March 2016 - 13:32

#3 93kts Posted 26 March 2016 - 13:56

#4 Cristianssenn Posted 26 March 2016 - 17:03

Anunturi

▶ 0 user(s) are reading this topic

Sign In

#1
93kts

Posted 26 March 2016 - 12:13

#2
Cristianssenn

Posted 26 March 2016 - 13:32

#3
93kts

Posted 26 March 2016 - 13:56

#4
Cristianssenn

Posted 26 March 2016 - 17:03