Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have the following table
| Num | Line |
| 1 | 10000 |
| 1 | 30000 |
| 2 | 20000 |
| 2 | 40000 |
| 3 | 10000 |
| 3 | 50000 |
| 3 | 10000 |
| 3 | 20000 |
| 4 | 10000 |
| 4 | 20000 |
and I just need this :
| Num | Line |
| 1 | 10000 |
| 2 | 30000 |
| 3 | 10000 |
| 4 | 10000 |
I need to only keep the smaller "LINE" for each number. Can I do it in the front end? or should I do it in the back end?
Thanks
@Manuel174102 as @Lakshminarayanan_J suggested you may have to share specific details as to why it doesn't work for you because all the suggestions seem correct.