Sousa Pambo

Sousa Pambo

  • NA
  • 92
  • 24.1k

get the Last and penultimate Data - vb. net and SQL

Dec 4 2015 6:18 AM
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 & "' "
 
idClientidConsumoName
52Luis Figo
23Paudio Paulo
44Joao Pinto
15Celsa Pambo
46Joao Pinto
57Luis Figo
28Paudio Paulo
59Luis Figo
 
Please HELP! 

Answers (3)