Reverse Sorting

Results 1 to 3 of 3

Thread: Reverse Sorting

  1. #1
    Join Date
    Dec 1969

    Default Reverse Sorting

    Is there a way to sort the results from a query in reverse order? I would like to sort some dates on my ASP page in reverse order (that is, starting with the most recent date).<BR><BR>Thanks.<BR>

  2. #2
    Markkk Guest

    Default RE: Reverse Sorting

    Using SQL you can:<BR><BR>"SELECT * FROM TableName ORDER BY DateFieldName DESC"<BR><BR>Your query will sort by the date field (DateFieldName) in DESCinding order. Of course, the field DateFiledName must be a valid field in the table TableName.<BR><BR>I hope this helps.

  3. #3
    Join Date
    Dec 1969

    Default ORDER BY <fieldname> DESC

    ORDER BY &#060;fieldname&#062; DESC<BR><BR>DESC is the keyword meaning "DESC"ending.<BR><BR>You can also use ASC (for "ASC"ending), but that&#039s the default.<BR><BR>

Posting Permissions

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