|
-
Feb 20th, 2001, 01:06 AM
#1
Thread Starter
Member
Hey guy's
I need to get the three most recently entered items from SQL table .. I have a Index field in the table that increments by 1 everytime a new value is entered.
I tried this
*******
Set rsResults = conn.Execute("SELECT TOP 3 Head_Index, Head_Headline, Head_Time FROM Headlines")
********
but all this gives me is the top three values in the table. How can I get the 3 bigest Index values out of the table?
Thanks in advance!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|