var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Displaying the 5 last records used
Is there a way i can display the 5 last storenames i've saved?
Like the myrecent document in ms office
Pls kindly help
How would you identify the last 5 storenames - do you have a timestamp next to each record?
You may wish to read this thread in the mySQL thread - the OP has asked a similar question to you (how do I select the top x...).
Also take a look in the helpfiles (or on google) for the TOP keyword in SQL.
SQL Server forum
Originally Posted by georgev
Also - there are a few silly posts in that thread. Ignore any that include "newid()".
ur codings are working excelent.
thanks guys...yep, hav a time stamp (date & time)
This is similar to what you need.
SELECT TOP 5 Storenames
ORDER BY TimeStamp DESC
Worked like a charm thanks
SELECT TOP 5 Sasol_Campaign_history.[Store Name] FROM Sasol_Campaign_history ORDER BY Sasol_Campaign_history.txtDate DESC , Sasol_Campaign_history.[Store Name];