SELECT TOP 5 * FROM table_name
WHERE table_name.id_field =
(
SELECT table_name.id_field FROM table_name ORDER BY table_name.id_field DESC
)
________________________________
From: Mark Henderson [mailto:[EMAIL PROTECTED]
I'm just wondering if there is an easier way to display only the the last 5
entries of a query without having to use, in my case, max(id) and then
subtracting 5. This means I have to do a couple of queries to get the
resulting output and I thought it might be possible to do everything inside
the one query.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
