MySQL Forums
Forum List  »  French

Re: Equivalent d'un LIMIT dans une sous requete
Posted by: Huu Da Tran
Date: May 23, 2008 01:00PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Equivalent d'un LIMIT dans une sous requete
3601
May 23, 2008 01:00PM


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.