I have the following table:
id | value | data | v
1 | val1 | dat1 | 1
2 | val1 | dat2 | 2
3 | val1 | dat3 | 3
4 | val2 | dat4 | 1
What I do is grab the data
, each value
, which has higher v
.
No what I mean ..
Sql output I would like:
id | value | data | v
3 | val1 | dat3 | 3
4 | val2 | dat4 | 1
See Question&Answers more detail:os