Check alle échte Black Friday-deals Ook zo moe van nepaanbiedingen? Wij laten alleen échte deals zien
Toon posts:

[ASP-SQL Query] Need the record before the last

Pagina: 1
Acties:
  • 185 views

Verwijderd

Topicstarter
Hello,
I have the following question:

To get the latest item i use the folowing code:
sSQL = "SELECT TOP 1 * FROM TblNews Order by Date DESC"

But now i need not the last item but the one just before that one!
Does anyone know the code as simple as possible please...

Thanks,
Fred

  • Creepy
  • Registratie: Juni 2001
  • Laatst online: 22:35

Creepy

Tactical Espionage Splatterer

Hi,

We're a dutch forum. Please repost in dutch and follow the guidelines given in Programming Beleid - De Quickstart.

"I had a problem, I solved it with regular expressions. Now I have two problems". That's shows a lack of appreciation for regular expressions: "I know have _star_ problems" --Kevlin Henney


Dit topic is gesloten.