Dreamweaver - Excluding the most recently added record in a list

Author

Excluding the most recently added record in a list

thesageuk

2004-08-13, 12:15 pm

This is probably a really simple task, but as I'm new to ASP pages, its
causing me major headaches!

Could anyone tell me the SQL code I would need to generate a list of
archived news items, but which EXCLUDES the most recently added piece of
news?

I'm trying to create a news page which looks something like this:

LATEST NEWS ITEM (News item 4)

Article content

RECENT NEWS ITEMS

News item 3 (link)
News item 2 (link)
News item 1 (link)

The code I have at the moment is as follows, but is obviously in need of the
filter to remove the most recent addition to the database:

SELECT *
FROM tblArticles
ORDER BY dateAdded DESC

Many thanks

Edge