I have a table:
id fkid foobar
1 1 345yellow
2 1 34 red
3 2 3459 green
4 2 345brown
I want to select the largest value of foo for a unique fkid, and return
bar, the results ordered by bar. In this case, 345 is the largest value of
foo for fkid 1, and
Hi
Try:
SELECT fkid, MAX(foo), bar FROM table GROUP BY fkid ORDER BY bar DESC
Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
select max(bar) from mytable where unique fkid order by bar asc
as far as I remember!!
-Original Message-
From: Peter Beckman [mailto:[EMAIL PROTECTED]
Sent: Lunes, 13 de Noviembre de 2006 04:59 p.m.
To: PHP-DB Mailing List
Subject: [PHP-DB] MySQL SQL Query Help
I have a table:
id
!!
-Original Message-
From: Peter Beckman [mailto:[EMAIL PROTECTED]
Sent: Lunes, 13 de Noviembre de 2006 04:59 p.m.
To: PHP-DB Mailing List
Subject: [PHP-DB] MySQL SQL Query Help
I have a table:
id fkid foobar
1 1 345yellow
2 1 34 red
3 2 3459 green
4 2
de Noviembre de 2006 04:59 p.m.
To: PHP-DB Mailing List
Subject: [PHP-DB] MySQL SQL Query Help
I have a table:
id fkid foobar
1 1 345yellow
2 1 34 red
3 2 3459 green
4 2 345brown
I want to select the largest value of foo for a unique fkid, and return
Peter Beckman wrote:
On Mon, 13 Nov 2006, [EMAIL PROTECTED] wrote:
Actually, that should not work, it should give you an error.
This should work:
SELECT `fkid`,max(`foo`) as foo,`bar` FROM `test2` GROUP BY `fkid`
ORDER BY `bar` ASC
Yes, but if the data is in a different order that fails