get me all players and get me even the last team in which he plays

#1

I've this select.

SELECT `Carrier`.`player_id`, `Carrier`.`team_id`,
`Carrier`.`created`
FROM `carriers` AS `Carrier`
ORDER BY `Carrier`.`team_id` ASC , `Carrier`.`player_id` ASC

that produce this output:

Player1 Team1 2011-04-02 10:02:59
Player2 Team1 2011-04-02 10:01:10
Player1 Team2 2011-04-02 10:05:26
Player2 Team2 2011-04-02 09:45:27

Now I need just the player's last team, so query should product
something like "for every Player get me the team with max
Carrier.created":

Player2 Team1 2011-04-02 10:01:10
Player1 Team2 2011-04-02 10:05:26

How can I rewrite the former query?

#2

Am 02.04.2011 12:53, schrieb Mariano C.:

Quote:

I've this select.

SELECT `Carrier`.`player_id`, `Carrier`.`team_id`,
`Carrier`.`created`
FROM `carriers` AS `Carrier`
ORDER BY `Carrier`.`team_id` ASC , `Carrier`.`player_id` ASC

that produce this output:

Player1 Team1 2011-04-02 10:02:59
Player2 Team1 2011-04-02 10:01:10
Player1 Team2 2011-04-02 10:05:26
Player2 Team2 2011-04-02 09:45:27

Now I need just the player's last team, so query should product
something like "for every Player get me the team with max
Carrier.created":

Player2 Team1 2011-04-02 10:01:10
Player1 Team2 2011-04-02 10:05:26

How can I rewrite the former query?

<http://dev.mysql.com/doc/refman/5.1/en/example-maximum-column-group-row.html>

HTH, Helmut

#3

On 2 Apr, 16:20, Helmut Chang <use... (AT) helmutchang (DOT) at> wrote:

Quote:

Am 02.04.2011 12:53, schrieb Mariano C.:

I've this select.

SELECT *`Carrier`.`player_id`, `Carrier`.`team_id`,
`Carrier`.`created`
FROM *`carriers` AS *`Carrier`
ORDER BY *`Carrier`.`team_id` ASC , *`Carrier`.`player_id` ASC

that produce this output:

Player1 * *Team1 * 2011-04-02 10:02:59
Player2 * *Team1 * 2011-04-02 10:01:10
Player1 * *Team2 * 2011-04-02 10:05:26
Player2 * *Team2 * 2011-04-02 09:45:27

Now I need just the player's last team, so query should product
something like "for every Player get me the team with max
Carrier.created":

Player2 * *Team1 * 2011-04-02 10:01:10
Player1 * *Team2 * 2011-04-02 10:05:26

How can I rewrite the former query?

http://dev.mysql.com/doc/refman/5.1/...column-group-r...

HTH, Helmut

Thank you

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

get me all players and get me even the last team in which he plays

comp.databases.mysql comp.databases.mysql

get me all players and get me even the last team in which he plays - 04-02-2011 , 05:53 AM

Re: get me all players and get me even the last team in which heplays - 04-02-2011 , 09:20 AM

Re: get me all players and get me even the last team in which he plays - 04-02-2011 , 10:10 AM