SQL Select problem

[matthew stuart]

I need to be able to select all records in a table apart from the most last, recent entry; or possibly select it but hide it somehow. I can't think of a way to do this or what the SQL might be, can any body advise me please?

Thanks.

Mat

[Newsgroup_User]

Mat

I would think that the SQL would look something like this

Select * from tablename
Where ID < (Select Max(ID) as TopIP from Tablename as TableName_1)

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"matthew stuart" <webforumsuser@macromedia.com> wrote in message
news:f1oiju$ra4$1@forums.macromedia.com...
>I need to be able to select all records in a table apart from the most
>last,
> recent entry; or possibly select it but hide it somehow. I can't think of
> a way
> to do this or what the SQL might be, can any body advise me please?
>
> Thanks.
>
> Mat
>