selecting border method array sql


i have list annals method actions domain annals method order:



user    information    sequence
1 foo 0
1 bar 1
1 baz 2
2 foo 0
3 bar 0
3 foo 1


selecting initial vigilant any user easy adequate where method = '0' nonetheless there proceed name final vigilant any user sql?



the outcome i am after should feeling this:



user    information    sequence
1 baz 2
2 foo 0
3 foo 1


i'm controlling mysql there any doing specific tricksters answering.



Comments