Hello, friends. I need your help. I'm programming in vb.net and I'd like to get the Last and the penultimate data Array among many data. E.g. Luis Figo. Note: I don't want to especify the value (7 ou 9). Actually the last is easy, I use: "select max(idConsumo) as idCon from tblClient where idClient = '" & idC & "' "
| idClient | idConsumo | Name |
| 5 | 2 | Luis Figo |
| 2 | 3 | Paudio Paulo |
| 4 | 4 | Joao Pinto |
| 1 | 5 | Celsa Pambo |
| 4 | 6 | Joao Pinto |
| 5 | 7 | Luis Figo |
| 2 | 8 | Paudio Paulo |
| 5 | 9 | Luis Figo |
Please HELP!