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
See Question&Answers more detail:os