Loading

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

Sousa Pambo

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!

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sousa Pambo10y ago
Hi fellows, I think I got the answer doing this .....

SELECT TOP 1 * From
(select Top 2 * from tbRegistConsumo where idcliente =5 ORDER BY idConsumo DESC) x
ORDER BY idConsumo

0
Sousa Pambo10y ago
Hi, it returns 2 records and I want one, the second last one. Thanx!
0
Manas Mohapatra10y ago
Try with below query:

SELECT TOP 2 idConsumo
FROM temp1 WHERE idClient = '" & idC & "' "
ORDER BY idConsumo DESC

0