selecting max value

pelegk2

i want to make a select on :
id num

28431 222.3347
28451 222.3346
28452 502.2256

where i want to get the max(id) but it's "num" too !!!
i tried :
select max(id),num from xxx group by id
and it gave me all the rows and not just the max(id)

what can i do?
thnaks in advane
peleg

Lars_Berg

select id,num
from xxx
where id in (select max(id) from xxx)

pelegk2

beacuse i cant make a nested select in mysql that is previous to 5
(and i have a version that is prior to 5)

any idea?:rolleyes:

Lars_Berg

select id,num
from xxx
order by id  desc
limit 1

You need 4.1 for subqueries, not 5.0

pelegk2

subqueries quries dosent work prior to version 5 of MySql

Roger_Ramjet

Yes they do. From the manual

Starting with MySQL 4.1, all subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific.

pelegk2

i tried to do it with mySql-front that connects to my DB and i recive a mistake!