List:General Discussion« Previous MessageNext Message »
From:Matthew Stuart Date:October 25 2007 10:55am
Subject:Select question
View as plain text  
I've got this statement to select the last two entries in my db:

SELECT top 2 *
FROM Content
ORDER BY ContentID desc

and it works fine because it selects the last two items entered into  
the db. However, I only want to be able to select item 2 rather than  
both 1 and 2. How do I do that?

Thanks

Mat



Thread
Select questionMatthew Stuart25 Oct
  • Re: Select questionRalf Hüsing25 Oct
  • RE: Select questionJerry Schwartz25 Oct