rpZ85Xjm

1Mysql sum of a column and group by where condition
2CREATE TABLE IF NOT EXISTS `party_sehir` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4   `plaka` int(11) NOT NULL,
5  `party_id` int(11) NOT NULL,
6  `player_id` int(11) NOT NULL,
7 `inf` int(11) NOT NULL,
8  PRIMARY KEY (`id`)
9) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
10
11
12INSERT INTO `party_sehir` (`id`, `plaka`, `party_id`, `player_id`, `inf`) VALUES
13(16, 35, 2, 2, 15),
14(17, 34, 1, 2, 10),
15(20, 35, 2, 2, 9),
16(21, 35, 2, 1, 9);
17	
18plaka - 35 , 24 (sum of inf) , party_id(2)
19plaka - 34 , 10 (sum of inf) , party_id(2)
20	
21I want to get  highest SUM OF INfs of a party_id of a plaka
22
23   like  in plaka 34 highest sum of infs is party_id 2 which is 10
24  in plaka 35 is party_id 1 33 , I want to show this for all plakas
25
26   for example plaka 34- with 10 inf party_id 1, plaka 35 with 33 infs party_id 2
27dataset should be
28 (plaka sumofinfs party_id)
29   34 10 2
30   35 33 1
31   36 50 4
32   44 95 7