Results 1 to 2 of 2

Thread: PROBLEM in SQL

  1. #1
    89 Guest

    Default PROBLEM in SQL

    Hello,<BR>The SQL-code for showing the top 5 posts from a table is.<BR>SQL - SELECT top 5 FROM table<BR><BR>But, i want to show the top1 latest (the latest) post in one place. And the the top 2-10 in another place. How to do?

  2. #2
    Join Date
    Dec 1969

    Default RE: PROBLEM in SQL

    If you have an ID field, then ORDER By IDField DESC should get you what you want.<BR><BR>HTH<BR><BR>Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts