Re: Equivalent d'un LIMIT dans une sous requete
Tu peux cependant utiliser un subselect comme sortie de table.
select avg(j1.`points`) as 'moyenne',
j1.`user_id` as 'user_id'
from `journee` as j1
left join (
select les 15 meilleures journées par joueur
) as j2 using (`user_id`)
...
J'espère que ça donne un bon point de départ,
H.
Subject
Views
Written By
Posted
8505
May 23, 2008 11:05AM
Re: Equivalent d'un LIMIT dans une sous requete
3654
May 23, 2008 01:00PM
3995
May 23, 2008 04:53PM
3612
May 26, 2008 12:23PM
3699
May 26, 2008 12:46PM
3842
May 29, 2008 03:53AM
3509
June 03, 2008 03:29PM
4235
June 06, 2008 11:43PM
3742
June 11, 2008 04:55PM
4457
May 23, 2008 11:26PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.