sql - get the row with the highest value in MySQL

Question

I want to get the highest value but group by another field on the same table ex:

seqid + fileid + name

1  |    1 | n1
2  |    1 | n2
3  |    2 | n3
4  |    3 | n4
5  |    3 | n5

the result must be

seqid + fileid + name

2  |    1 | n2
3  |    2 | n3
5  |    3 | n5

note: all the field must be display like using select * I'll appreciate any help.tnx

Answer 1

How about something like

SELECT  t.*
FROM    Table t INNER JOIN
        (
            SELECT  fileid,
                    MAX(seqid) Maxseqid
            FROM    Table
            GROUP BY    fileid
        ) m ON  t.fileid = m.fileid
            AND t.seqid = m.Maxseqid