| 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 question | Matthew Stuart | 25 Oct |
| • Re: Select question | Ralf Hüsing | 25 Oct |
| • RE: Select question | Jerry Schwartz | 25 Oct |
